ผู้ใช้ตามสถานที่และแท็ก ไม่จำเป็นต้องใช้ตารางทั้งหมด
Users by Location and Tag.It is not neccessary to use all the tables.
 Posts:  Id [ number]  PostTypeId [ number]  AcceptedAnswerId [ number]  ParentId [ number]  CreationDate [ time]  DeletionDate [ time]  Score [ number]  ViewCount [ number]  Body [ text]  OwnerUserId [ number]  OwnerDisplayName [ text]  LastEditorUserId [ number]  LastEditorDisplayName [ text]  LastEditDate [ time]  LastActivityDate [ time]  Title [ text]  Tags [ text]  AnswerCount [ number]  CommentCount [ number]  FavoriteCount [ number]  ClosedDate [ time]  CommunityOwnedDate [ time]  ContentLicense [ text] 
SELECT ROW_NUMBER() OVER (ORDER BY Reputation DESC) AS "#", u.Id AS "user_link", u.Reputation, COUNT(p.Id) FROM Users AS u INNER JOIN Posts AS p ON p.OwnerUserId = u.Id INNER JOIN PostTags AS pt ON pt.PostId = p.Id INNER JOIN Tags AS t ON t.Id = pt.TagId WHERE LOWER(Location) LIKE LOWER('%##Location##%') AND t.TagName = '##tagname##' GROUP BY u.Reputation, u.Id ORDER BY Reputation DESC