Number of comments per month by user


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

  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

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