Untitled
unknown
sql
4 years ago
329 B
6
Indexable
select h.hacker_id, h.name from Submissions as s join Hackers as h on s.hacker_id = h.hacker_id join Challenges as c on s.challenge_id = c.challenge_id join Difficulty as d on c.Difficulty_level = d.Difficulty_level where s.score = d.score group by h.hacker_id, h.name having count(*) > 1 order by count(*) desc, h.hacker_id;
Editor is loading...