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,H.name
FROM Submissions as S
LEFT JOIN Challenges as C on C.challenge_id=S.challenge_id
LEFT JOIN Difficulty as D on C.difficulty_level=D.difficulty_level
LEFT JOIN Hackers as H on H.hacker_id=S.hacker_id
Where S.score=D.score
Group by S.hacker_id,H.name
having Count()>1
Order by Count() desc, S.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 S.hacker_id,H.name FROM Submissions as S LEFT JOIN Challenges as C on C.challenge_id=S.challenge_id LEFT JOIN Difficulty as D on C.difficulty_level=D.difficulty_level LEFT JOIN Hackers as H on H.hacker_id=S.hacker_id Where S.score=D.score Group by S.hacker_id,H.name having Count()>1 Order by Count() desc, S.hacker_id asc