Tag count by date

0

Please login or register to vote for this query.

(click on this box to dismiss)

German Language Meta

Q&A about the site for speakers of German wanting to discuss the finer points of the language and translation

select t.TagName,
count(case when p.CreationDate between '2007-1-1' and '2021-2-1' then 1 else null end) as Total
from Posts p
join PostTags pt on pt.PostId = p.Id
join Tags t on t.Id = pt.TagId
and t.TagName in ('actionscript','apex','arduino')
group by t.TagName

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results