instruction: Popular tags over last 30 days.
response: WITH tags_info AS (SELECT TagName, Votes.Id AS V_Id, Posts.Id AS P_Id, Posts.OwnerUserId AS P_OwnerUserId, Posts.CreationDate AS P_CreationDate FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.Id INNER JOIN Posts ON Posts.ParentId = PostTags.PostId AND Posts.PostTypeId = 2 INNER JOIN Votes ON Votes.PostId = Posts.Id AND VoteTypeId = 2) SELECT TagName FROM tags_info WHERE P_CreationDate >= DATEADD(DD, -30, GETDATE()) GROUP BY TagName HAVING COUNT(P_Id) >= 90 ORDER BY TagName