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