Q&A for gardeners and landscapers
SELECT *, count(*) AS count FROM ( SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, CreationDate), 0) AS [date], t.TagName as [tag] FROM Posts p JOIN PostTags pt ON pt.PostId = p.Id JOIN Tags t ON t.Id = pt.TagId WHERE t.tagName IN ('java') ) as X GROUP BY [tag], date ORDER BY [tag], date