We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Basic Join
  4. Top Competitors
  5. Discussions

Top Competitors

  • pavkova_tereza
     + 0 comments

    Hey, I created this solution, I am getting error with the CTE syntax, but can't see the mistake, can anyone point me in the right direction? 

    WITH CTE_merge AS
(
SELECT d.score,
        c.challenge_id,
        c.hacker_id
FROM challenges c INNER JOIN difficulty d
    ON c.difficulty_level=d.difficulty_level
)
SELECT h.hacker_id,
    h.name
FROM hacker_id h INNER JOIN submissions s
    ON h.hacker_id=s.hacker_id
    INNER JOIN CTE_merge ct 
    ON s.challenge_id=ct.challenge_id AND s.score=ct.score
GROUP BY h.hacker_id, h.hacker_name
HAVING COUNT(s.challenge_id)>1
ORDER BY COUNT(s.challenge_id) DESC, h.hacker_id