We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
select hacker_id, name
from (select h.name, h.hacker_id
from hackers h
join submissions s on h.hacker_id=s.hacker_id
join challenges ch on s.challenge_id=ch.challenge_id
join difficulty df on ch.difficulty_level=df.difficulty_level
where s.score=df.score
order by h.hacker_id)
as maxxx
group by hacker_id, name
having count(name) > 1
order by count(name)desc, hacker_id asc
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Top Competitors
You are viewing a single comment's thread. Return to all comments →
select hacker_id, name from (select h.name, h.hacker_id from hackers h join submissions s on h.hacker_id=s.hacker_id join challenges ch on s.challenge_id=ch.challenge_id join difficulty df on ch.difficulty_level=df.difficulty_level where s.score=df.score order by h.hacker_id) as maxxx group by hacker_id, name having count(name) > 1 order by count(name)desc, hacker_id asc