Q&A for serious players and enthusiasts of chess
SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, CreationDate), 0) AS [Month] , Count(*) AS COUNT FROM Posts INNER JOIN PostTags ON PostTags.PostId = Posts.Id INNER JOIN Tags ON PostTags.TagId = Tags.Id WHERE Tags.TagName = 'firebase' AND PostTypeId = 1 GROUP BY DATEADD(MONTH, DATEDIFF(MONTH, 0, CreationDate), 0) ORDER BY [Month] DESC