You are viewing a single comment's thread. Return to all comments →
MySQL
WITH list_name AS( SELECT c.hacker_id, h.name, COUNT(c.challenge_id) AS challenges_created FROM Hackers h JOIN Challenges c ON h.hacker_id = c.hacker_id GROUP BY c.hacker_id, h.name ORDER BY COUNT(c.challenge_id) DESC, c.hacker_id), count_challenges AS( SELECT challenges_created, COUNT(challenges_created) AS counter FROM list_name GROUP BY challenges_created HAVING COUNT(challenges_created) = 1) SELECT list_name.hacker_id, list_name.name, list_name.challenges_created FROM list_name WHERE list_name.challenges_created = (SELECT MAX(challenges_created) FROM list_name) OR list_name.challenges_created IN (SELECT count_challenges.challenges_created FROM count_challenges);
Seems like cookies are disabled on this browser, please enable them to open this website
Challenges
You are viewing a single comment's thread. Return to all comments →
MySQL