0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in the history and origins of science and mathematics

DECLARE @SelectedTags varchar(max) = ##SelectedTags:string?google-sheets,gmail,facebook,google-drive,google-docs,youtube,twitter##;

SELECT year(Posts.CreationDate) AS Year, TagName, 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
WHERE PostTypeId = 1
AND TagName IN (SELECT LOWER(value) FROM STRING_SPLIT(@SelectedTags,',') )
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 2 Rubén

created apr 19 15 muru