ผู้ใช้อันดับต้นๆ ตามสถานที่และแท็ก ไม่จำเป็นต้องใช้ตารางทั้งหมด
Top users by location and tag.It is not neccessary to use all the tables.
 PostNoticeTypes:  Id [ number]  ClassId [ number]  Name [ text]  Body [ text]  IsHidden [ boolean]  Predefined [ boolean]  PostNoticeDurationId [ number] 
SELECT ROW_NUMBER() OVER (ORDER BY Score DESC) AS "#", u.Id AS "user_link", u.DisplayName, u.Age, tuser.Answers, tuser.Score, u.Reputation FROM Users AS u JOIN (SELECT Answers.OwnerUserId AS UserId, SUM(Answers.Score) AS Score, COUNT(*) AS Answers FROM Tags AS t JOIN PostTags AS pt ON t.Id = pt.TagId JOIN Posts AS p ON p.Id = pt.PostId JOIN Posts AS Answers ON Answers.ParentId = p.Id WHERE t.TagName = '##TagName##' GROUP BY Answers.OwnerUserId) AS tuser ON tuser.UserId = u.Id WHERE LOWER(u.Location) LIKE LOWER('%##Location##%') ORDER BY Score DESC