instruction: Site-wide average score per post per month and post type id.
response: SELECT YEAR(CreationDate) AS "Year", MONTH(CreationDate) AS "Month", PostTypeId AS "Post Type", AVG(CAST(Score AS FLOAT)) AS "Average", SUM(Score) AS "Sum Score", COUNT(Id) AS "Post Count" FROM Posts WHERE ClosedDate IS NULL AND CommunityOwnedDate IS NULL AND PostTypeId < 3 GROUP BY PostTypeId, YEAR(CreationDate), MONTH(CreationDate) ORDER BY Year, Month, PostTypeId