Q&A about the site for members of the workforce navigating the professional setting
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 = 'spring-framework' 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;