0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

SELECT
    t.TagName,
    DatePart(quarter, p.LastActivityDate) AS q,
    Year(p.LastActivityDate) AS y, 
    COUNT(p.Id) As NumPosts
  FROM Posts p
  JOIN PostTags pt ON p.Id = pt.PostId
  JOIN Tags t ON t.Id = pt.TagId
  where Year(p.LastActivityDate) = 2023 and DatePart(quarter, p.LastActivityDate) = 3
  GROUP BY DatePart(quarter, p.LastActivityDate), Year(p.LastActivityDate), t.TagName
  ORDER BY y, q, NumPosts DESC

view current version

edited oct 3 23

created jan 4 22 Tom.Palmer