Q&A for SharePoint enthusiasts
SELECT tagname, COUNT(*) AS Posts FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.id INNER JOIN Posts ON Posts.ParentId = PostTags.PostId where posts.creationdate > '2024-10-01' group by tagname;