Answered questions per month

0

Please login or register to vote for this query.

(click on this box to dismiss)

MathOverflow

Q&A for professional mathematicians

select
month(p.CreationDate), 
(select count(q.Id) from Posts q where year(q.CreationDate) = ##Year## and month(q.CreationDate) = month(p.CreationDate) and q.PostTypeId = 1),
count(p.Id), 
count(p.AcceptedAnswerId)
from Posts p
where year(p.CreationDate) = ##Year## and p.PostTypeId = 1 and p.AnswerCount > 0
group by month(p.CreationDate)
order by month(p.CreationDate) asc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results