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(score) as mx
from (
select h.hacker_id, h.name, s.challenge_id, max(s.score) as score
from hackers h
join submissions s
on h.hacker_id = s.hacker_id
group by h.hacker_id, h.name, s.challenge_id
) a
group by hacker_id, name
having mx > 0
order by mx 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 →
select hacker_id, name, sum(score) as mx from ( select h.hacker_id, h.name, s.challenge_id, max(s.score) as score from hackers h join submissions s on h.hacker_id = s.hacker_id group by h.hacker_id, h.name, s.challenge_id ) a group by hacker_id, name having mx > 0 order by mx desc, hacker_id