Q&A for experienced flyers, pilots, and builders of drones and model aircraft
SELECT MONTH(CreationDate) AS Month, YEAR(CreationDate) AS Year, COUNT(PostTypeId), COUNT(ID) FROM posts GROUP BY YEAR(CreationDate), MONTH(CreationDate), PostTypeId ORDER BY PostTypeId ASC;