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(a) from (select s.hacker_id,h.name,max(s.score) a from Submissions s inner join hackers h on h.hacker_id=s.hacker_id where s.score!=0 group by s.hacker_id,h.name,s.challenge_id) group by hacker_id,name order by 3 desc,1;
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 →
Oracle solution :
select hacker_id,name,sum(a) from (select s.hacker_id,h.name,max(s.score) a from Submissions s inner join hackers h on h.hacker_id=s.hacker_id where s.score!=0 group by s.hacker_id,h.name,s.challenge_id) group by hacker_id,name order by 3 desc,1;