Q&A for people looking to bypass life's everyday problems with simple tricks
SELECT YEAR(Posts.CreationDate) AS Year, MONTH(Posts.CreationDate) AS Month, COUNT(Posts.Id) AS PostCount, AVG(Posts.Score) AS AverageScore, SUM(Posts.ViewCount) AS TotalViewCount FROM Posts WHERE Posts.CreationDate >= '2022-01-01' AND Posts.CreationDate < '2023-02-01' GROUP BY YEAR(Posts.CreationDate), MONTH(Posts.CreationDate) ORDER BY Year, Month