s/283693/is-there-a-way-to-see-the-what-percentage-you-are-in-a-specular-tag ไม่จำเป็นที่จะต้องใช้ตารางทั้งหมด
s/283693/is-there-a-way-to-see-the-what-percentage-you-are-in-a-particular-tagIt is not neccessary to use all the tables.
 PostNotices:  Id [ number]  PostId [ number]  PostNoticeTypeId [ number]  CreationDate [ time]  DeletionDate [ time]  ExpiryDate [ time]  Body [ text]  OwnerUserId [ number]  DeletionUserId [ number] 
WITH tagleague AS (SELECT p.OwnerUserId, SUM(Score) AS score, COUNT(*) AS posts, RANK() OVER (ORDER BY SUM(Score) DESC) AS tagrank FROM Posts AS p INNER JOIN PostTags AS pt ON pt.PostId = COALESCE(p.ParentId, p.Id) INNER JOIN Tags AS t ON t.Id = pt.TagId WHERE t.TagName = '##tagname:string?java##' AND NOT p.OwnerUserId IS NULL AND PostTypeId IN (1, 2) GROUP BY OwnerUserId) SELECT OwnerUserId AS "user_link", (CAST(tagrank AS FLOAT) / (SELECT COUNT(*) FROM tagleague) * 100) AS perc, (SELECT COUNT(*) FROM tagleague) AS total, tagrank FROM tagleague WHERE OwnerUserId = '##userid:int?1475228##'