0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

SELECT datepart(year,posts.CreationDate), 
       datepart(month,posts.CreationDate),
       count(*)
FROM Posts 
WHERE PostTypeId = 1 
GROUP BY datepart(year,posts.CreationDate), 
         datepart(month,posts.CreationDate)
ORDER BY datepart(year,posts.CreationDate), 
         datepart(month,posts.CreationDate)

fork query

edited may 20

created may 20 anonymous