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(q.CreationDate),
    count(q.Id) as NQs,
    TagName
from PostTags pt
join Posts q on q.Id=pt.PostId
join Tags t on t.Id=pt.TagId
where TagName in ('java','javascript', 'python', 'HTML/CSS','SQL')
-- posts are questions
and q.PostTypeId = 1
-- question isn't closed
AND q.ClosedDate IS NULL
-- questsion doesn't have answers
AND q.AnswerCount = 0


GROUP BY Year(q.CreationDate), TagName

ORDER BY Year(q.CreationDate)

fork query

edited dec 15 22 jon.doe32071

created sep 8 15 anonymous