Top Competitors

문제 풀이 링크: https://www.hackerrank.com/challenges/full-score/problem?isFullScreen=true

Top Competitors | HackerRank

---

SELECT hacker_id,
    name
FROM (
    SELECT h.hacker_id,
        h.name,
        s.challenge_id
    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 d.score = s.score
    ) full_score
GROUP BY hacker_id, name
HAVING COUNT(challenge_id) > 1
ORDER BY COUNT(challenge_id) DESC, hacker_id