Q&A for linguists, teachers and students of the Korean language
SELECT 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));