You are viewing a single comment's thread. Return to all comments →
MySQL:
with cte(a,b,c,d) as (select h.hacker_id,h.name,count(c.challenge_id), count(h.hacker_id) over(partition by count(c.challenge_id)) from hackers h join challenges c on h.hacker_id=c.hacker_id group by 1,2 order by 3 desc,1) select a,b,c from cte where d=1 or c=(select max(c) from cte);
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: