Questions per month top 10 tags compared

0

Please login or register to vote for this query.

(click on this box to dismiss)

How many questions per month does each tag in the top 10 tags get

Q&A for Ubuntu users and developers

select *, count(*) from
(
  select CAST(
      cast(DATEPART(YYYY, CreationDate) as varchar) + '-' + cast(DATEPART(MM, CreationDate) as varchar) + '-01'
    as datetime) [Month], 
    t.TagName
  from Posts p 
  join PostTags pt on pt.PostId = p.Id
  join Tags t on t.Id = pt.TagId
  where TagId in 
  (
    select Id from Tags 
    where TagName LIKE '%f#%'
  )
  and CreationDate > '1/1/2011'
) as X
group by TagName, [Month]
order by [Month] asc, TagName asc

Enter Parameters

Options:
Switch to meta site
Hold tight while we fetch your results
{"cc_re__cc_re__cc_by_sa_4_0": ["/a>\r\n                <a href=\"https://data.stackexchange.com\">data</a>\r\n                <a href=\"https://stackexchange.com/legal\">legal</a>\r\n                <strong><a href=\"https://meta.stackexchange.com/contact\">contact us</a></strong>\r\n                <strong><a href=\"https://meta.stackexchange.com\">feedback</a></strong>\r\n            </div>\r\n            <div id=\"copyright\">\r\n                Site design / logo &copy; 2024 Stack Exchange Inc; \r\n                user contributions licensed under <a href=\"https://creativecommons.org/licenses/by-sa/4.0/\" rel=\"license\">cc by-sa</a>; see the <a href=\"https://stackoverflow.com/help/licensing\">licensing help page</a> for more info\r\n            </div>\r\n            <div id=\"revision\">rev 2023.1.23.89</div>\r\n        </div>\r\n    </div>\r\n    <noscript>\r\n        <div id=\"noscript-warning\">\r\n            Data Explorer works best with JavaScript enabled</div>\r\n    </noscript>\r\n    <script>\r\n(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){\r\n(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date("], "copyright__copyright__copyright": ["ast(DATEPART(YYYY, CreationDate) as varchar) + '-' + cast(DATEPART(MM, CreationDate) as varchar) + '-01'\n    as datetime) [Month], \n    t.TagName\n  from Posts p \n  join PostTags pt on pt.PostId = p.Id\n  join Tags t on t.Id = pt.TagId\n  where TagId in \n  (\n    select Id from Tags \n    where TagName LIKE '%f#%'\n  )\n  and CreationDate > '1/1/2011'\n) as X\ngroup by TagName, [Month]\norder by [Month] asc, TagName asc\n\nEnter Parameters\n\nOptions:\nSwitch to meta site\nHold tight while we fetch your results"]}