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 A.Hacker_id,D.Name
From Submissions A JOIN Challenges B
ON A.challenge_id=B.challenge_id
JOIN Difficulty C ON B.Difficulty_level=C.Difficulty_level
JOIN Hackers D ON A.Hacker_id=D.Hacker_id
where C.score=A.score
group by A.Hacker_id, D.Name
having count(A.challenge_id)>1 order by count(A.challenge_id) desc, A.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 A.Hacker_id,D.Name From Submissions A JOIN Challenges B ON A.challenge_id=B.challenge_id JOIN Difficulty C ON B.Difficulty_level=C.Difficulty_level JOIN Hackers D ON A.Hacker_id=D.Hacker_id where C.score=A.score group by A.Hacker_id, D.Name having count(A.challenge_id)>1 order by count(A.challenge_id) desc, A.Hacker_id asc