You are viewing a single comment's thread. Return to all comments →
Oracle:
SELECT id,name FROM( SELECT hid.hacker_id as id, hid.name as name, Count(hacker_id) as cnt FROM Hackers hid JOIN Submissions s ON hid.hacker_id = s.hacker_id JOIN Challenges c ON s.challenge_id = c.challenge_id JOIN Difficulty d ON c.difficulty_level = d.difficulty_level WHERE d.score = s.score GROUP BY hid.hacker_id , hid.name ORDER BY Count(hacker_id) DESC, hid.hacker_id) WHERE cnt > 1 ;
Seems like cookies are disabled on this browser, please enable them to open this website
Top Competitors
You are viewing a single comment's thread. Return to all comments →
Oracle: