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, name, sum(max_score) as total_score
from (select h.hacker_id, name, s.challenge_id, max(s.score) as max_score
from Hackers h join Submissions s on h.hacker_id = s.hacker_id
group by h.hacker_id, name, s.challenge_id) t
group by hacker_id, name
having total_score > 0
order by total_score desc, hacker_id;
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 →
/MySQL solution/
select hacker_id, name, sum(max_score) as total_score from (select h.hacker_id, name, s.challenge_id, max(s.score) as max_score from Hackers h join Submissions s on h.hacker_id = s.hacker_id group by h.hacker_id, name, s.challenge_id) t group by hacker_id, name having total_score > 0 order by total_score desc, hacker_id;