We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
SELECT
h.hacker_id,
h.name,
t.total_score
FROM
Hackers h
JOIN (
SELECT
hacker_id,
SUM(max_score) AS total_score
FROM (
SELECT
hacker_id,
challenge_id,
MAX(score) AS max_score
FROM Submissions
GROUP BY hacker_id, challenge_id
) AS max_scores
GROUP BY hacker_id
) t ON h.hacker_id = t.hacker_id
WHERE
t.total_score > 0
ORDER BY
t.total_score DESC,
h.hacker_id ASC;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Contest Leaderboard
You are viewing a single comment's thread. Return to all comments →
SELECT h.hacker_id, h.name, t.total_score FROM Hackers h JOIN ( SELECT hacker_id, SUM(max_score) AS total_score FROM ( SELECT hacker_id, challenge_id, MAX(score) AS max_score FROM Submissions GROUP BY hacker_id, challenge_id ) AS max_scores GROUP BY hacker_id ) t ON h.hacker_id = t.hacker_id WHERE t.total_score > 0 ORDER BY t.total_score DESC, h.hacker_id ASC;