[HackerRank] Contest Leaderboard

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT hacker_id, name, SUM(score) AS total_score
FROM (SELECT h.hacker_id, h.name, s.challenge_id, MAX(s.score) AS score
      FROM Hackers AS h
        LEFT JOIN Submissions AS s ON h.hacker_id = s.hacker_id
      GROUP BY h.hacker_id, h.name, s.challenge_id) AS high_score
GROUP BY hacker_id, name
HAVING SUM(score) != 0
ORDER BY total_score DESC, hacker_id ASC