Q&A for SharePoint enthusiasts
SELECT FORMAT(Posts.CreationDate, 'yyyy-MM') AS Month, COUNT(*) AS TotalQuestions FROM Posts JOIN PostTags ON Posts.Id = PostTags.PostId JOIN Tags ON PostTags.TagId = Tags.Id WHERE Tags.TagName = 'NumPy' AND Posts.CreationDate >= '2008-01-01' AND Posts.CreationDate < '2024-05-01' GROUP BY FORMAT(Posts.CreationDate, 'yyyy-MM') ORDER BY Month;