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
hacker_id,
(SELECT name FROM Hackers WHERE Hackers.hacker_id = S.hacker_id) AS name,
SUM(score) AS total_score
FROM (
SELECT
hacker_id,
challenge_id,
MAX(score) AS score
FROM
Submissions
GROUP BY
hacker_id, challenge_id
) AS S
GROUP BY
hacker_id
HAVING
SUM(score) > 0
ORDER BY
total_score DESC,
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 hacker_id, (SELECT name FROM Hackers WHERE Hackers.hacker_id = S.hacker_id) AS name, SUM(score) AS total_score FROM ( SELECT hacker_id, challenge_id, MAX(score) AS score FROM Submissions GROUP BY hacker_id, challenge_id ) AS S GROUP BY hacker_id HAVING SUM(score) > 0 ORDER BY total_score DESC, hacker_id ASC;