instruction: Meteor thread volume with accepted answers by month.
response: SELECT DATEADD(m, DATEDIFF(m, 0, CreationDate), 0) AS Month, COUNT(*) AS AcceptedAnswers FROM Tags LEFT JOIN PostTags ON PostTags.TagId = Tags.Id LEFT JOIN Posts ON Posts.Id = PostTags.PostId LEFT JOIN PostTypes ON PostTypes.Id = Posts.PostTypeId WHERE Tags.TagName = 'meteor' AND PostTypeId = 1 AND CommunityOwnedDate IS NULL AND ClosedDate IS NULL AND AcceptedAnswerId > 0 AND CreationDate >= DATEADD(m, DATEDIFF(m, 0, GETDATE()) - 48, 0) GROUP BY DATEADD(m, DATEDIFF(m, 0, CreationDate), 0), Tags.TagName ORDER BY DATEADD(m, DATEDIFF(m, 0, CreationDate), 0), Tags.TagName