Q&A about the site for administrators, end users, developers and designers for Craft CMS
SELECT PostTypeId, COUNT(*) as NrOfPosts FROM posts WHERE YEAR(CreationDate) = '2019' GROUP BY PostTypeId;