You are viewing a single comment's thread. Return to all comments →
oracle my solution
select a.hacker_id, h.name, a.cnt from ( SELECT hacker_id, COUNT (hacker_id) cnt, MAX (COUNT (hacker_id)) OVER () mx, COUNT (COUNT (hacker_id)) OVER (PARTITION BY COUNT (hacker_id)) rep_cnt FROM challenges GROUP BY hacker_id ) a join hackers h on (a.hacker_id = h.hacker_id) where not (rep_cnt>1 and cnt<mx) order by 3 desc, 1 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 →
oracle my solution