You are viewing a single comment's thread. Return to all comments →
Can anyone please explain me why below doesn't work?
SELECT h.hacker_id, h.name, SUM(s.score) as score_sum FROM Hackers h INNER JOIN Submissions s ON h.hacker_id = s.hacker_id WHERE s.score = ( SELECT MAX(s2.score) FROM Submissions s2 WHERE s2.hacker_id = s.hacker_id AND s2.challenge_id = s.challenge_id ) GROUP BY h.hacker_id, h.name HAVING score_sum > 0 ORDER BY score_sum 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 →
Can anyone please explain me why below doesn't work?