Q&A for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
SELECT DATEADD(m, DATEDIFF(m, 0, Posts.CreationDate), 0) AS Month, Tags.TagName AS Tag , Count(*) AS Questions 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 ='dplyr' AND PostTypes.Name = 'Question' AND CreationDate >= DATEADD(m, DATEDIFF(m, 0, GETDATE())-50,0) AND CreationDate < DATEADD(m, DATEDIFF(m, 0, GETDATE()), 0) GROUP BY DATEADD(m, DATEDIFF(m, 0, Posts.CreationDate), 0), Tags.TagName ORDER BY DATEADD(m, DATEDIFF(m, 0, Posts.CreationDate), 0), Tags.TagName;