You are viewing a single comment's thread. Return to all comments →
SELECT S.hacker_id, H.name FROM Submissions S JOIN Challenges C on C.challenge_id = S.challenge_id JOIN Difficulty D on D.difficulty_level = C.difficulty_level JOIN Hackers H on H.hacker_id = S.hacker_id WHERE D.difficulty_level = C.difficulty_level AND D.score = S.score GROUP BY S.hacker_id, H.name HAVING COUNT(S.hacker_id) > 1 ORDER BY COUNT(S.hacker_id) DESC, S.hacker_id ASC
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 →