0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for software developers, mathematicians and others interested in cryptography

SELECT
  FORMAT(CreationDate, 'yyyy') AS [year],
  FORMAT(CreationDate, 'MM') AS [month],
  COUNT(*) AS [posts]
FROM Posts
WHERE PostTypeId IN (1)
GROUP BY FORMAT(CreationDate, 'yyyy'), FORMAT(CreationDate, 'MM')
ORDER BY [year], [month]

fork query

created dec 12 Rob44351