0

Please login or register to vote for this query.

(click on this box to dismiss)

Android questions per day in 2011

Q&A for anime and manga fans

select 
  year(p.CreationDate) as [Year],
  month(p.CreationDate) as [Month],
  count(*) as [QuestionsAskedThisMonth]
from Posts p 
  inner join PostTags pt on p.id = pt.postid
  inner join Tags t on t.id = pt.tagid
group by year(p.CreationDate), month(p.CreationDate)
with rollup
order by year(p.CreationDate) desc, month(p.CreationDate) desc

fork query

edited jan 27 12 anonymous

created dec 7 11 Kishor Nanda