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.
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;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Top Competitors
You are viewing a single comment's thread. Return to all comments →