Вопросы и ответы о сайте для программистов
SELECT eomonth(CreationDate), COUNT(Id) AS Posts, SUM(case when PostTypeId = 1 then 1 else 0 end) AS Questions, SUM(case when PostTypeId = 2 then 1 else 0 end) AS Answers FROM Posts WHERE (Score>=##min?50##) AND (CommunityOwnedDate IS NULL) GROUP BY eomonth(CreationDate) ORDER BY eomonth(CreationDate) ASC