Q&A for anime and manga fans
SELECT YEAR(CreationDate) AS Year, 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 '2008-12-31' ) AND CreationDate <= DATEADD(DAY, 30, (SELECT MIN(CreationDate) FROM Posts)) GROUP BY YEAR(CreationDate) ORDER BY Year;