0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Drupal developers and administrators

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 = 'scipy'
  AND Posts.CreationDate >= '2008-01-01'
  AND Posts.CreationDate < '2024-05-01'
GROUP BY
  FORMAT(Posts.CreationDate, 'yyyy-MM')
ORDER BY
Month;

fork query

edited may 26 anonymous

created may 26 user25244630