You are viewing a single comment's thread. Return to all comments →
MySQL
WITH CTE AS( SELECT hacker_id H, COUNT(challenge_id) T, DENSE_RANK() OVER(PARTITION BY COUNT(challenge_id) ORDER BY COUNT(challenge_id) DESC, hacker_id ASC) R FROM Challenges GROUP BY hacker_id ORDER BY T DESC, H ASC), CTE2 AS( SELECT T, COUNT(R) FROM CTE GROUP BY T HAVING COUNT(R) = 1 OR T = (SELECT MAX(T) FROM CTE)) SELECT H, name, T FROM CTE JOIN HACKERS H ON H.hacker_id = CTE.H WHERE T IN (SELECT T FROM CTE2) ORDER BY T DESC, H ASC
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