Number of comments per month by user

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)

Space Exploration

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results