0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for community managers, administrators, and moderators

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) >= 2018
GROUP BY DatePart(quarter, p.LastActivityDate), Year(p.LastActivityDate), t.TagName
ORDER BY y, q, NumPosts DESC

fork query

edited oct 20 20 anonymous

created jul 11 16 Nat Dunn