You are viewing a single comment's thread. Return to all comments →
with main as ( select hackers.hacker_id, hackers.name, count(challenges.challenge_id) as "chall_count" from hackers left join challenges on hackers.hacker_id = challenges.hacker_id group by hackers.hacker_id, hackers.name ) select * from main where chall_count not in ( select chall_count from main where chall_count < (select max(chall_count) from main) group by chall_count having count(*) > 1 ) order by chall_count desc, hacker_id 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 →