Q&A about the site for music historians, critics, and fans
SELECT DATEFROMPARTS(YEAR(P.CreationDate), MONTH(P.CreationDate), 1) AS Date, CASE WHEN P.PostTypeId = 1 THEN 'questions' ELSE 'answers' END AS TYPE, COUNT(*) AS NewAnswers FROM Posts P WHERE P.PostTypeId IN (1, 2) -- Questions, Answers AND YEAR(P.CreationDate) >= 2020 GROUP BY DATEFROMPARTS(YEAR(P.CreationDate), MONTH(P.CreationDate), 1), P.PostTypeId ORDER BY Date