0

Please login or register to vote for this query.

(click on this box to dismiss)

Number of questions per month with a certain tag.

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

-- Tagged questions per month
-- Number of questions per month with a certain tag.

select year(CreationDate) as "Year", month(CreationDate) as "Month", count(*) as "Questions"
from Posts
where Tags like '%##Tag##%' -- yes, I know, this matches substrings too.
group by year(CreationDate), month(CreationDate)
order by 1 desc, 2 desc

fork query

created feb 2 11 badp