0

Please login or register to vote for this query.

(click on this box to dismiss)

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 TagId = 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

view current version

edited sep 13

created sep 13 jon.doe45688