You are viewing a single comment's thread. Return to all comments →
select h.hacker_id, h.name
from Hackers h join Submissions s using(hacker_id)
join Challenges c using(challenge_id)
join Difficulty d using(difficulty_level)
where s.score = d.score and c.difficulty_level=d.difficulty_level
group by h.hacker_id, h.name
having count(s.submission_id)>1
order by count(s.submission_id) desc,hacker_id
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 →
-- EASY TO UNDERSTAND AND LESS CODE --
select h.hacker_id, h.name
from Hackers h join Submissions s using(hacker_id)
join Challenges c using(challenge_id)
join Difficulty d using(difficulty_level)
where s.score = d.score and c.difficulty_level=d.difficulty_level
group by h.hacker_id, h.name
having count(s.submission_id)>1
order by count(s.submission_id) desc,hacker_id