Q&A for SharePoint enthusiasts
SELECT DATEPART(MONTH, CreationDate) AS MONTHNumber, SUM(CASE WHEN PostTypeId = 1 THEN 1 ELSE 0 END) AS TotalQuestionsCount, SUM(CASE WHEN PostTypeId = 2 THEN 1 ELSE 0 END) AS TotalAnswersCount FROM Posts WHERE OwnerUserId IN ( SELECT Id FROM Users WHERE CreationDate BETWEEN '2008-01-01' AND '2024-12-31' ) AND CreationDate <= DATEADD(DAY, 30, (SELECT MIN(CreationDate) FROM Posts)) GROUP BY DATEPART(MONTH, CreationDate) ORDER BY MONTHNumber;