0

Please login or register to vote for this query.

(click on this box to dismiss)

Number of comments per month by user (excludes deleted comments)

Q&A for spacecraft operators, scientists, engineers, and enthusiasts

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

view current version

edited aug 6 12 anonymous

created dec 7 11 Kishor Nanda