0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people studying math at any level and professionals in related fields

--select DATEPART(month, CreationDate), count(*) from Posts p JOIN PostTags pt on (p.Id=pt.PostId) Join Tags t 
--on (pt.TagId=t.Id) group by DATEPART(month, CreationDate) order by count(*) desc;

select DATEPART(month, CreationDate), count(*) from Posts group by DATEPART(month, CreationDate) 
order by count(*) desc;

fork query

edited dec 3

created dec 3 anonymous