You are viewing a single comment's thread. Return to all comments →
MySQL
SELECT CONCAT(user_count.hacker_id, ' ', user_count.name) FROM (SELECT COUNT(*) AS repetitions, HACKERS.hacker_id, HACKERS.name FROM SUBMISSIONS JOIN HACKERS ON SUBMISSIONS.hacker_id = HACKERS.hacker_id JOIN CHALLENGES ON SUBMISSIONS.challenge_id = CHALLENGES.challenge_id JOIN DIFFICULTY ON CHALLENGES.difficulty_level = DIFFICULTY.difficulty_level WHERE SUBMISSIONS.score = DIFFICULTY.score GROUP BY HACKERS.hacker_id, HACKERS.name) AS user_count WHERE repetitions>1 ORDER BY repetitions DESC, user_count.hacker_id ASC;
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 →
MySQL