0

Please login or register to vote for this query.

(click on this box to dismiss)

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)

fork query

created jan 18 Martin20528