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 -- AI: Aggregation Interval (MONTH, YEAR, WEEK)