Q&A for community managers, administrators, and moderators
SELECT eomonth(DeletionDate), COUNT(DeletionDate) AS Deleted FROM PostsWithDeleted WHERE PostTypeId=1 GROUP BY eomonth(DeletionDate) ORDER BY eomonth(DeletionDate) ---Posts which are not deleted have DeletionDate NULL ---So COUNT(DeletionDate) only counts Deleted Posts