SELECT Month, Count(*) FROM (SELECT Id, DATEADD(MONTH, DA...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results