รับแท็กยอดนิยมของผู้ใช้ตามลำดับ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Getting a user's most popular tags in order.It is not neccessary to use all the tables.
 PostsWithDeleted:  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 UserPosts AS (SELECT * FROM Posts WHERE OwnerUserId = '##UserId##'), TagCount AS (SELECT COUNT(*) AS Cnt, TagId FROM PostTags WHERE PostId IN (SELECT Id FROM UserPosts WHERE PostTypeId = 1 UNION ALL SELECT ParentId FROM UserPosts WHERE PostTypeId = 2) GROUP BY TagId) SELECT TagName, Cnt FROM TagCount AS TC JOIN Tags AS T ON TC.TagId = T.Id ORDER BY Cnt DESC