Untitled
Anonymous
sql
11/25/2021 9:29 AM
440 B
26
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...