Q&A about the site for enthusiasts and scholars of mythology and folklore
SELECT DATEPART(WEEK, CreationDate) AS WeekNumber, 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 '2009-01-01' AND '2010-12-31' ) AND CreationDate <= DATEADD(DAY, 30, (SELECT MIN(CreationDate) FROM Posts)) GROUP BY DATEPART(WEEK, CreationDate) ORDER BY WeekNumber;