Top Competitors

  • + 0 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