You are viewing a single comment's thread. Return to all comments →
Oracle Version
select hacker_id, name, sum(total_score) as total_score from (select s.hacker_id, name, challenge_id, max(score) as total_score from hackers h join submissions s on h.hacker_id = s.hacker_id where score > 0 group by s.hacker_id, challenge_id, name) group by hacker_id, name order by total_score desc, hacker_id;
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 Version