select
  tags,
  extract(year from creation_date) year,
  extract(quarter from creation_date) quarter,
  count(*) count
from `bigquery-public-data.stackoverflow.posts_questions`
group by tags, year, quarter
order by count(*) desc

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