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(total)
from (select h.hacker_id,name,challenge_id,max(score) as total
from Hackers h
left join submissions s on s.hacker_id = h.hacker_id
group by h.hacker_id,name,challenge_id
) as N
group by hacker_id,name
having sum(total) > 0
order by sum(total) 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,name,sum(total) from (select h.hacker_id,name,challenge_id,max(score) as total from Hackers h left join submissions s on s.hacker_id = h.hacker_id group by h.hacker_id,name,challenge_id ) as N group by hacker_id,name having sum(total) > 0 order by sum(total) desc,hacker_id asc