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