Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences
SELECT FORMAT(p.CreationDate, 'yy-MM') as [Month], COUNT(p.Id) as TotalQuestions FROM Posts p INNER JOIN PostTags pt ON pt.PostId = p.Id INNER JOIN Tags t ON t.Id = pt.TagId WHERE p.PostTypeId = 1 -- 1=Question AND t.TagName = 'java' GROUP BY FORMAT(p.CreationDate, 'yy-MM') ORDER BY [Month];