How many questions per month does each tag in the top 10 tags get
プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答
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 tagname in ('rust', 'haskell', 'clojure', 'groovy', 'ada', 'lua', 'erlang', 'julia', 'elixir', 'd' ) ) as X where Month < '2019-12-01' group by TagName, [Month] order by [Month] asc, TagName asc