Q&A for students and teachers of all martial arts
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) = 2024 and DatePart(quarter, p.LastActivityDate) = 3 GROUP BY DatePart(quarter, p.LastActivityDate), Year(p.LastActivityDate), t.TagName ORDER BY y, q, NumPosts DESC