You are viewing a single comment's thread. Return to all comments →
MySQL query:
SELECT HACKERS.HACKER_ID,HACKERS.NAME,SUM(SUBMISSIONS.SCORE) FROM HACKERS INNER JOIN (SELECT SUBMISSIONS.CHALLENGE_ID,SUBMISSIONS.HACKER_ID,MAX(SUBMISSIONS.SCORE) AS SCORE FROM SUBMISSIONS GROUP BY SUBMISSIONS.CHALLENGE_ID,SUBMISSIONS.HACKER_ID ORDER BY SUBMISSIONS.HACKER_ID DESC)SUBMISSIONS ON HACKERS.HACKER_ID = SUBMISSIONS.HACKER_ID GROUP BY HACKERS.HACKER_ID, HACKERS.NAME HAVING SUM(SUBMISSIONS.SCORE) >0 ORDER BY SUM(SUBMISSIONS.SCORE) DESC, HACKERS.HACKER_ID ASC
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 query: