You are viewing a single comment's thread. Return to all comments →
SELECT hackers.hacker_id, hackers.name FROM hackers JOIN submissions ON submissions.hacker_id = hackers.hacker_id JOIN challenges ON challenges.challenge_id = submissions.challenge_id JOIN difficulty ON difficulty.difficulty_level = challenges.difficulty_level WHERE difficulty.score = submissions.score GROUP BY 1, 2 HAVING COUNT(*) > 1 ORDER BY COUNT(*) DESC, hackers.hacker_id;
Seems like cookies are disabled on this browser, please enable them to open this website
Top Competitors
You are viewing a single comment's thread. Return to all comments →
For MySQL Platform