Q&A for people interested in conceptual questions about life and challenges in a world where "cognitive" functions can be mimicked in purely digital environment
SELECT FORMAT(CreationDate, 'yyyy-MM-dd'), COUNT(1) AS Total, sum(CASE WHEN PostTypeId = 1 THEN 1 else 0 END) as quest, sum(CASE WHEN AnswerCount > 0 THEN 1 else 0 END) as answer FROM Posts WHERE YEAR(CreationDate) = 2020 AND MONTH(CreationDate) IN (12) GROUP BY FORMAT(CreationDate, 'yyyy-MM-dd') ORDER BY 1