Q&A about the site for music historians, critics, and fans
-- How many questions per month for JVM languages? -- Mostly high-profile languages, including some wip select *, count(*) from ( select CAST( cast(DATEPART(YYYY, CreationDate) as varchar) + '-' + cast(DATEPART(MM, CreationDate) as varchar) + '-01' as date) Month, t.TagName from Posts p join PostTags pt on pt.PostId = p.Id join Tags t on t.Id = pt.TagId where t.TagName in ( 'scala', 'groovy', 'clojure', 'oxygen', 'jruby', 'jython', 'rhino', 'mirah', 'joy', 'ceylon', 'kotlin', 'fan') ) as X group by TagName, Month order by Month asc, count(*) desc