ข้อมูลผู้ใช้ที่มีแท็ก 10 อันดับแรก ไม่จำเป็นต้องใช้ตารางทั้งหมด
user info with top 10 tags.It is not neccessary to use all the tables.
 CloseReasonTypes:  Id [ number]  Name [ text]  Description [ text] 
WITH tagList AS (SELECT t.TagName, COUNT(t.TagName) AS tagCount FROM Tags AS t INNER JOIN PostTags AS pt ON pt.TagId = t.Id INNER JOIN Posts AS q ON pt.PostId = q.Id INNER JOIN Posts AS a ON q.AcceptedAnswerId = a.Id WHERE a.OwnerUserId = @UserId AND a.PostTypeId = 2 GROUP BY t.TagName ORDER BY tagCount DESC LIMIT 10) SELECT u.Id, u.DisplayName, u.Reputation, CONCAT(@LinkPrefix, u.Id) AS Link, (SELECT COUNT(*) FROM Posts WHERE PostTypeId = 2 AND OwnerUserId = @UserId) AS Answers, (SELECT COUNT(*) FROM Posts AS q INNER JOIN Posts AS a ON q.AcceptedAnswerId = a.Id WHERE a.OwnerUserId = @UserId) AS Accepted FROM Users AS u WHERE u.Id = @UserId