서브쿼리 해커랭스 Challenges 풀이

WITH COUNTER AS
SELECT H.hacker_id AS hacker_id, H.name AS name, COUNT(*) AS challenges_created
FROM Hackers AS H LEFT JOIN Challenges AS C ON H.hacker_id = C.hacker_id
GROUP BY hacker_id

SELECT hacker_id, name, challenges_created
FROM COUNTER 
WHERE challenges_created NOT IN (SELECT challenges_created FROM(SELECT *
                                 FROM COUNTER 
                                 GROUP BY challenges_created HAVING COUNT(*)>=2))
OR challenges_created >= (SELECT challenges_created FROM COUNTER ORDER BY challenges_created LIMIT 1)
ORDER BY challenges_created DESC, hacker_id; 

이렇게 풀면 왜 답이 안나오는지 잘 모르겠습니다.ㅠㅠ

challenges_created값이 중복일때 제거해주는 부분 NOT IN 절에 오류가 있는 것 같ㅇ느데 어떤 부분이 틀린걸까요