Number of Questions per month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android questions per day in 2011

Stack Overflow

Q&A for professional and enthusiast programmers

select 
  year(p.CreationDate) as [Year],
  month(p.CreationDate) as [Month],
  count(*) as [Questions]
from PostHistory p
where PostHistoryTypeId = 1
group by year(p.CreationDate), month(p.CreationDate)
order by year(p.CreationDate) asc, month(p.CreationDate) asc

Enter Parameters

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