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

( -- Questions
select year(Posts.CreationDate) as [Post Year], 'Questions' as [Type], 
count(*) as [Total Count]
FROM Tags
JOIN PostTags on PostTags.TagId = Tags.Id
JOIN Posts on Posts.Id = PostTags.PostId
JOIN Votes v on Posts.Id = v.PostId
where v.PostId is null and Posts.PostTypeId = 1
AND year(Posts.CreationDate) >= 2010
AND year(Posts.CreationDate) < year(GETDATE())
group by year(Posts.CreationDate)
)
UNION
( -- Answers 
select year(Posts.CreationDate) as [Post Year], 'Answers' as [Type], 
count(*) as [Total Count]
from Tags
JOIN PostTags on PostTags.TagId = Tags.Id
JOIN Posts on Posts.Id = PostTags.PostId
JOIN Votes v on Posts.Id = v.PostId
where v.PostId is null and Posts.PostTypeId = 2
AND year(Posts.CreationDate) >= 2010
AND year(Posts.CreationDate) < year(GETDATE())
group by year(Posts.CreationDate)

)

fork query

edited feb 3 Rubén

created feb 23 20 avalokan