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.
  1. Prepare
  2. SQL
  3. Basic Join
  4. Contest Leaderboard
  5. Discussions

Contest Leaderboard

  • jwu112
     + 10 comments

    MYSQL:

    SELECT h.hacker_id, h.name, 
sum(scr) as tot
FROM Hackers h, 
    (
        SELECT s2.hacker_id as hac_id, 
        s2.challenge_id as ch_id, 
        max(s2.score) as scr
        FROM Submissions s2
        GROUP BY s2.hacker_id,s2.challenge_id
        having scr > 0
    ) AS chart1
WHERE h.hacker_id = hac_id
GROUP BY h.hacker_id
ORDER BY tot DESC, h.hacker_id