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

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

)
order by year(p.CreationDate);

fork query

edited feb 3 Rubén

created feb 23 20 avalokan