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 h.hacker_id,h.name
from Hackers h join Submissions s on h.hacker_id=s.hacker_id
left join Challenges ch on ch.challenge_id = s.challenge_id
left join Difficulty d on d.difficulty_level = ch.difficulty_level
where s.score = d.score
Group By h.hacker_id,h.name
Having count(distinct ch.challenge_id ) > 1
Order by count(distinct ch.challenge_id) desc, h.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 h.hacker_id,h.name from Hackers h join Submissions s on h.hacker_id=s.hacker_id left join Challenges ch on ch.challenge_id = s.challenge_id left join Difficulty d on d.difficulty_level = ch.difficulty_level where s.score = d.score Group By h.hacker_id,h.name Having count(distinct ch.challenge_id ) > 1 Order by count(distinct ch.challenge_id) desc, h.hacker_id asc