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