Q&A about the site for administrators and users of the CiviCRM Constituent Relationship Management software
SELECT PostTypeId, COUNT(*) as NrOfPosts FROM posts GROUP BY PostTypeId;