with counter as ( select hackers.hacker_id , <a target="_blank" rel="noopener noreferrer nofollow" href="http://hackers.name">hackers.name</a> , count(*) as challenges_created from Challenges inner join Hackers on Challenges.hacker_id = Hackers.hacker_id group by hackers.hacker_id, <a target="_blank" rel="noopener noreferrer nofollow" href="http://hackers.name">hackers.name</a>)계속 아래와 같은 오류가 발생합니다 ㅠㅠㅠ<ul><li>&nbsp;<pre class="hljs"><code>Msg 102, Level 15, State 1, Server dbrank-tsql, Line 8</code></pre></li><li>Incorrect syntax near ')'</li></ul>&nbsp;란 오류가 자꾸 발생합니다 ㅠㅠ&nbsp;

참고 : Stack Overflow - <a target="_blank" rel="noopener noreferrer nofollow" href="https://stackoverflow.com/questions/45376755/with-clause-incorrect-syntax-near-sql-server-2016">https://stackoverflow.com/questions/45376755/with-clause-incorrect-syntax-near-sql-server-2016</a> 간단히 말해 불완전한 구문이라 에러가 발생한다고 설명하고 있습니다. with ~ as ~ 문은 마지막에 SELECT 해줘야 된다고 합니다. 작성자님이 작성하신 with counter as (~~~) select * from counter 해줘야 하는것 같습니다. 잘 동작했으면 좋겠네요!

Inflearn Community Q&A

똑같이 작성했는데 오류가 발생합니다 ㅠ