ผู้ใช้อันดับต้นๆ ตามสถานที่และแท็ก สร้างโดย samliew (http//stackoverflow.com/users/584192/samuel-liew) ไม่จำเป็นต้องใช้ตารางทั้งหมด
Top Users by location and tag. Created by samliew (http//stackoverflow.com/users/584192/samuel-liew)It is not neccessary to use all the tables.
 CloseReasonTypes:  Id [ number]  Name [ text]  Description [ text] 
SELECT Users.Id AS "user_link", SUM(Answers.Score) AS Score, Tags.TagName FROM Posts AS Answers INNER JOIN Posts AS ParentQuestions ON ParentQuestions.Id = Answers.ParentId INNER JOIN Users AS Users ON Answers.OwnerUserId = Users.Id INNER JOIN PostTags ON PostTags.PostId = Answers.ParentId INNER JOIN Tags ON Tags.Id = PostTags.TagId WHERE Users.Id < 150000000 AND Users.Id >= 15000000 AND LOWER(Location) LIKE LOWER('%Russia%') GROUP BY Users.Id, Tags.TagName ORDER BY Score