Top Competitors

  • + 1 comment

    Oracle Solution: select h.hacker_id, h.name from hackers h left join submissions s on s.hacker_id = h.hacker_id left join challenges c on c.challenge_id = s.challenge_id inner join difficulty d on d.difficulty_level = c.difficulty_level and d.score = s.score group by h.hacker_id, h.name having count(c.challenge_id) >1 order by count(c.challenge_id) desc,h.hacker_id; Reach me for an clarifications.