Top Competitors

  • + 1 comment
    • why is this throwing an error: WITH cte1 AS( SELECT h.hacker_id AS id, h.name AS name, count(distinct s.challenge_id) FROM Hackers h JOIN Submissions s ON h.hacker_id = s.hacker_id JOIN Challenges c ON c.challenge_id = s.challenge_id JOIN Difficulty d ON d.difficulty_level = c.difficulty_level WHERE s.score = d.score ) SELECT id, name FROM cte1 GROUP BY id, name HAVING COUNT(DISTINCT challenge_id) > 1 ORDER BY COUNT(DISTINCT challenge_id) DESC, id ASC;