Compare occurrence of two tags month by month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Unix and Linux

Q&A for users of Linux, FreeBSD and other Un*x-like operating systems

-- 
-- 

select t.TagName, 
       LEFT(CONVERT(varchar, p.CreationDate,112),6) as [YYYYMM], 
count(*)
from Posts p
join PostTags pt on pt.PostId = p.Id
join Tags t on t.Id = pt.TagId 
where t.TagName = ##Tag1:string?python##
or t.TagName = ##Tag2:string?javascript##
group by t.TagName,
         LEFT(CONVERT(varchar, p.CreationDate,112),6)
order by [YYYYMM] desc

Enter Parameters

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