แท็กยอดนิยมและผู้ใช้อันดับต้นๆ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Top tags and their top users.It is not neccessary to use all the tables.
 Tags:  Id [ number]  TagName [ text]  Count [ number]  ExcerptPostId [ number]  WikiPostId [ number] 
SELECT TagName, 'count', OwnerUserId AS "user_link", Score FROM (SELECT t.TagName, t.Count, a.OwnerUserId, SUM(a.Score) AS Score, RANK() OVER (PARTITION BY t.TagName ORDER BY SUM(a.Score) DESC) AS Rank FROM Posts AS a INNER JOIN Posts AS q ON a.ParentId = q.Id INNER JOIN PostTags AS pt ON q.Id = pt.PostId INNER JOIN Tags AS t ON t.Id = pt.TagId WHERE a.PostTypeId = 2 AND a.CommunityOwnedDate IS NULL AND t.Id IN (SELECT TOP(100) AS Id FROM Tags ORDER BY 'count' DESC) GROUP BY t.TagName, t.Count, a.OwnerUserId) AS temp WHERE Rank = 1 ORDER BY 'count' DESC