Q&A for science fiction and fantasy enthusiasts
SELECT Month, Count(*) FROM (SELECT Id, DATEADD(MONTH, DATEDIFF(MONTH, 0, CreationDate), 0) as [Month] FROM Posts JOIN PostTags ON PostId = Id WHERE PostTypeId IN (1, 2) AND PostId = 4452 AND (Posts.Body LIKE '%medical%' OR Posts.Body LIKE '%clinical%' OR Posts.Title LIKE '%medical%' OR Posts.Title LIKE '%clinical%' OR Tags LIKE '%medical%' )) as tmp GROUP BY Month ORDER BY Month