Q&A for science fiction and fantasy 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 = 'r' AND Posts.CreationDate >= '2008-01-01' AND Posts.CreationDate < '2024-05-01' AND Title LIKE '%clinical%' GROUP BY FORMAT(Posts.CreationDate, 'yyyy-MM') ORDER BY Month;