Tags by Quarter


Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

    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

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results