Q&A about the site for people interested in the history and origins of science and mathematics
SELECT DATEPART(YEAR, CreationDate) AS [Year], DATEPART(MONTH, CreationDate) AS [Month], COUNT(*) AS [Number of Questions] FROM Posts WHERE PostTypeId = 1 -- Only questions AND CreationDate >= DATEADD(YEAR, -2, GETDATE()) -- Last 2 years GROUP BY DATEPART(YEAR, CreationDate), DATEPART(MONTH, CreationDate) ORDER BY [Year] DESC, [Month] DESC