instruction: Number of posts by calendar year, with deleted.
response: SELECT TIME_TO_STR(CreationDate, '%Y') AS year, COUNT(Id) AS postsCount FROM Posts WHERE PostTypeId = '##type?2##' GROUP BY TIME_TO_STR(CreationDate, '%Y') ORDER BY TIME_TO_STR(CreationDate, '%Y')