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 Q
  JOIN PostTags ON PostId = Id
  WHERE PostTypeId IN (1, 2) AND Tags IN ('R') AND (Body LIKE '%medical%' OR  Body LIKE '%clinical%' OR Title LIKE '%medical%' OR Title LIKE '%clinical%' OR Tags LIKE '%medical%' )) as tmp
GROUP BY Month
ORDER BY Month
/*4452

view current version

edited sep 13

created sep 13 jon.doe45688