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