instruction: Count of existing and deleted posts by their type.
response: SELECT MIN(PostTypes.Name) AS Name, COUNT(*) AS Count FROM Posts, PostTypes WHERE Posts.PostTypeId = PostTypes.Id GROUP BY PostTypes.Id ORDER BY Count DESC