แท็กยอดนิยมในช่วง 30 วันที่ผ่านมา ไม่จำเป็นต้องใช้ตารางทั้งหมด
Popular tags over last 30 days.It is not neccessary to use all the tables.
 Posts:  Id [ number]  PostTypeId [ number]  AcceptedAnswerId [ number]  ParentId [ number]  CreationDate [ time]  DeletionDate [ time]  Score [ number]  ViewCount [ number]  Body [ text]  OwnerUserId [ number]  OwnerDisplayName [ text]  LastEditorUserId [ number]  LastEditorDisplayName [ text]  LastEditDate [ time]  LastActivityDate [ time]  Title [ text]  Tags [ text]  AnswerCount [ number]  CommentCount [ number]  FavoriteCount [ number]  ClosedDate [ time]  CommunityOwnedDate [ time]  ContentLicense [ text] 
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