Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language
SELECT DATEPART(YEAR, CreationDate) AS [Year], DATEPART(MONTH, CreationDate) AS [Month], COUNT(*) AS [Number of Questions] FROM Posts WHERE PostTypeId = 2 -- Only questions AND CreationDate >= DATEADD(YEAR, -12, GETDATE()) -- Last 2 years GROUP BY DATEPART(YEAR, CreationDate), DATEPART(MONTH, CreationDate) ORDER BY [Year] DESC, [Month] DESC