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 S
JOIN challenges C ON S.challenge_id = C.challenge_id
JOIN difficulty D ON C.difficulty_level = D.difficulty_level
JOIN hackers H ON S.hacker_id = H.hacker_id
WHERE S.score = D.score
GROUP BY S.hacker_id, H.name
HAVING COUNT(S.submission_id) > 1
ORDER BY COUNT(S.submission_id) DESC, 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, H.name FROM submissions S JOIN challenges C ON S.challenge_id = C.challenge_id JOIN difficulty D ON C.difficulty_level = D.difficulty_level JOIN hackers H ON S.hacker_id = H.hacker_id WHERE S.score = D.score GROUP BY S.hacker_id, H.name HAVING COUNT(S.submission_id) > 1 ORDER BY COUNT(S.submission_id) DESC, hacker_id;