Questions/answers/closed questions per months


Please login or register to vote for this query.

(click on this box to dismiss)

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

  SUM(Case When p.PostTypeId=1 Then 1 Else 0 End) AS [Questions],
  SUM(Case When p.PostTypeId=2 Then 1 Else 0 End) AS [Answers],
  COUNT (p.ClosedDate) AS [Closed Questions]
FROM Posts p
GROUP BY eomonth(p.CreationDate)
ORDER BY eomonth(p.CreationDate)

Enter Parameters

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