0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to bypass life's everyday problems with simple tricks

/*SELECT Id FROM */
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%') */
  ) as tmp
GROUP BY Month
ORDER BY Month

view current version

edited sep 13

created sep 13 jon.doe45688