Q&A for Ubuntu users and developers
SELECT COUNT(distinct Id) as NumberofPosts, YEAR(CreationDate) as YEAR, MONTH(CreationDate) as MONTH FROM Posts GROUP BY YEAR(CreationDate), MONTH(CreationDate) ORDER BY YEAR(CreationDate), MONTH(CreationDate);