Questions/answers/closed questions per months

0

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

SELECT 
  eomonth(p.CreationDate),
  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

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