0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT 
    Year(p.CreationDate),
    count(p.Id) as NQs

FROM Posts p


WHERE
-- posts are questions
p.PostTypeId = 1
-- question isn't closed
AND p.ClosedDate IS NULL
-- questsion doesn't have answers
AND p.AnswerCount = 0


GROUP BY Year(p.CreationDate)

ORDER BY Year(p.CreationDate)

fork query

edited dec 14 22

created dec 14 22 jon.doe32071