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.
selecth.hacker_id,name,sum(score)astotal_scorefromhackersashinnerjoin/* find max_score*/(selecthacker_id,max(score)asscorefromsubmissionsgroupbychallenge_id,hacker_id)max_scoreonh.hacker_id=max_score.hacker_idgroupbyh.hacker_id,name/* don't accept hackers with total_score=0 */havingtotal_score>0/* finally order as required */orderbytotal_scoredesc,h.hacker_id;
Contest Leaderboard
You are viewing a single comment's thread. Return to all comments →