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 s.hacker_id, name
from submissions s
join hackers h on s.hacker_id = h.hacker_id
join Challenges c on s.challenge_id = c.challenge_id
join Difficulty d on c.difficulty_level = d.difficulty_level
group by s.hacker_id, name
having sum(case when s.score = d.score then 1 else 0 end)>1
order by sum(case when s.score = d.score then 1 else 0 end) desc, s.hacker_id
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 s.hacker_id, name from submissions s join hackers h on s.hacker_id = h.hacker_id join Challenges c on s.challenge_id = c.challenge_id join Difficulty d on c.difficulty_level = d.difficulty_level group by s.hacker_id, name having sum(case when s.score = d.score then 1 else 0 end)>1 order by sum(case when s.score = d.score then 1 else 0 end) desc, s.hacker_id