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
  FORMAT(Posts.CreationDate, 'yyyy-MM') AS Month,
  COUNT(*) AS TotalQuestions
FROM
  Posts
JOIN
  PostTags ON Posts.Id = PostTags.PostId
JOIN
  Tags ON PostTags.TagId = Tags.Id
WHERE
  Tags.TagName = 'r'
  AND Posts.CreationDate >= '2008-01-01'
  AND Posts.CreationDate < '2024-05-01'
  /*AND Title LIKE '%clinical%' */
GROUP BY
  FORMAT(Posts.CreationDate, 'yyyy-MM')
ORDER BY
Month;

fork query

edited sep 13

created sep 13 jon.doe45688