เพื่อเพิ่มคะแนนแท็กของคุณ ไม่จำเป็นต้องใช้ตารางทั้งหมด
s, to increase your tag score.It is not neccessary to use all the tables.
 PostLinks:  Id [ number]  CreationDate [ time]  PostId [ number]  RelatedPostId [ number]  LinkTypeId [ number] 
WITH TagScores AS (SELECT PostTags.TagId, SUM(5 - 2 * Votes.VoteTypeId) AS Score FROM Posts, Votes, PostTags WHERE Posts.ParentId = PostTags.PostId AND Votes.PostId = Posts.Id AND Votes.VoteTypeId BETWEEN 2 AND 3 AND Posts.OwnerUserId = @UserId AND Posts.CommunityOwnedDate IS NULL GROUP BY PostTags.TagId) SELECT * FROM TagScores