Top Competitors

  • + 0 comments

    Oracle:

    SELECT id,name  FROM(
    SELECT hid.hacker_id as id,
        hid.name as name,
        Count(hacker_id) as cnt
    FROM Hackers hid
    JOIN Submissions s ON hid.hacker_id = s.hacker_id
    JOIN Challenges c ON s.challenge_id = c.challenge_id
    JOIN Difficulty d ON c.difficulty_level = d.difficulty_level
    WHERE d.score = s.score
    GROUP BY hid.hacker_id , hid.name
    ORDER BY Count(hacker_id) DESC, hid.hacker_id)
    WHERE cnt > 1 ;