Q&A for community managers, administrators, and moderators
SELECT DATEADD(##AI##, DATEDIFF(##AI##, 0, CreationDate), 0) AS [##AI##] , COUNT(DISTINCT Posts.Id) AS Count FROM Posts INNER JOIN PostTags ON PostTags.PostId = Posts.Id INNER JOIN Tags ON PostTags.TagId = Tags.Id WHERE Tags.TagName like 'firebase%' AND PostTypeId = 1 AND CreationDate > '2012-01-01' GROUP BY DATEADD(##AI##, DATEDIFF(##AI##, 0, CreationDate), 0) ORDER BY [##AI##] DESC /*SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, CreationDate), 0) AS [MONTH] , COUNT(DISTINCT Posts.Id) AS Count FROM Posts INNER JOIN PostTags ON PostTags.PostId = Posts.Id INNER JOIN Tags ON PostTags.TagId = Tags.Id WHERE Tags.TagName like 'firebase%' AND PostTypeId = 1 AND CreationDate > '2012-01-01' GROUP BY DATEADD(MONTH, DATEDIFF(MONTH, 0, CreationDate), 0) ORDER BY [MONTH] DESC*/