SELECT DATEADD(##period?month##, DATEDIFF(##period?month#...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics Meta

Q&A about the site for people studying math at any level and professionals in related fields

SELECT
  DATEADD(##period?month##, DATEDIFF(##period?month##, 0, CreationDate), 0) AS OnDate,  
  COUNT(DISTINCT IIF(PostTypeId = 1, Id, NULL)) Questions,
  COUNT(DISTINCT IIF(PostTypeId = 2, Id, NULL)) Answers 
FROM 
  Posts  

GROUP BY
  DATEADD(##period?month##, DATEDIFF(##period?month##, 0, CreationDate), 0)
ORDER BY
  DATEADD(##period?month##, DATEDIFF(##period?month##, 0, CreationDate), 0) ASC

Enter Parameters

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