Q&A for users of Linux, FreeBSD and other Un*x-like operating systems
SELECT PostTypeId, COUNT(*) as NrOfPosts FROM posts WHERE YEAR(CreationDate) = '2019' GROUP BY PostTypeId;