Stat language trends over time by month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Data

Q&A for developers and researchers interested in open data

select tmp.yearmon as YEARMON, 
       tmp.tagname as TAGNAME, 
       count(*) as COUNT FROM (
      select CAST(
                  CAST(DATEPART(YYYY, CreationDate) as varchar) + '-' + 
                  CAST(DATEPART(MM, CreationDate) as varchar) + '-01'
                  as date) yearmon,  -- Is there a better way to do this?
             t.TagName as tagname 
       from Posts p 
       join PostTags pt on pt.PostId = p.Id
       join Tags t on t.Id = pt.TagId
       where t.TagName in ('r', 'pandas', 'julia', 'excel', 'spss', 'sas')
       ) tmp
group by YEARMON, TAGNAME
order by YEARMON DESC, TAGNAME ASC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results