Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more
SELECT DATEPART(YEAR, Posts.CreationDate) Year, DATEPART(MONTH, Posts.CreationDate) Month, COUNT(Posts.Id) Questions FROM Posts WHERE PostTypeid = 1 -- 1 = Question GROUP BY DATEPART(YEAR, Posts.CreationDate), DATEPART(MONTH, Posts.CreationDate) ORDER BY Year, Month