0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

SELECT year(Posts.CreationDate) AS Year, Count(*) as 'Question Count',
coalesce(count(case when AnswerCount > 0 then 0 end), 0) as 'Answered', 
-- coalesce(count(case when AnswerCount > 0 then 0 end)*100/count(*), 0) as 'Answer Rate', 
coalesce(count(case when ClosedDate is not null then 1 end), 0) as 'Closed'
-- coalesce(count(case when ClosedDate != 0 then 1 end)*100/count(*), 0) as 'Closure Rate' 
FROM Tags
JOIN PostTags on Tags.Id = PostTags.TagId 
JOIN Posts on Posts.Id = PostId
JOIN Votes v on Posts.Id = v.PostId
WHERE v.PostId is null 
AND Posts.PostTypeId = 1 
AND TagName = ##SelectedTag:string?google-sheets##
AND year(Posts.CreationDate) >= 2010
AND year(Posts.CreationDate) < year(GETDATE())
GROUP BY TagName, year(Posts.CreationDate)
ORDER BY year(Posts.CreationDate) ASC, Count(*) DESC

fork query

edited feb 3 Rubén

created feb 23 20 avalokan