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, Name from
submissions s
join challenges c on s.challenge_id=c.challenge_id
join difficulty d on d.difficulty_level=c.difficulty_level
join Hackers h on s.hacker_id=h.hacker_id
where s.score=d.score
group by h.Hacker_ID, Name
having count(submission_id)>1
order by count(submission_id) desc,h.Hacker_ID
Top Competitors
You are viewing a single comment's thread. Return to all comments →
select h.Hacker_ID, Name from submissions s join challenges c on s.challenge_id=c.challenge_id join difficulty d on d.difficulty_level=c.difficulty_level join Hackers h on s.hacker_id=h.hacker_id
where s.score=d.score group by h.Hacker_ID, Name having count(submission_id)>1 order by count(submission_id) desc,h.Hacker_ID