ผู้ใช้ SO iOS อันดับต้นๆ ในคราคูฟ..ไม่จำเป็นต้องใช้ตารางทั้งหมด
Top SO iOS users in krakow..It is not neccessary to use all the tables.
 SuggestedEdits:  Id [ number]  PostId [ number]  CreationDate [ time]  ApprovalDate [ time]  RejectionDate [ time]  OwnerUserId [ number]  Comment [ text]  Text [ text]  Title [ text]  Tags [ text]  RevisionGUID [ other] 
SELECT DisplayName AS "display_name", Users.Id AS "user_link", SUM(CASE Votes.VoteTypeId WHEN 2 THEN 1 WHEN 3 THEN -1 END) AS Score FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.Id INNER JOIN Posts ON Posts.ParentId = PostTags.PostId INNER JOIN Users ON Posts.OwnerUserId = Users.Id INNER JOIN Votes ON Votes.PostId = Posts.Id WHERE (LOWER(Location) LIKE '%krak%' OR LOWER(Location) LIKE '%cracow%') AND (Tags.TagName = 'ios' OR Tags.TagName = 'objective-c' OR Tags.TagName = 'swift') AND Reputation > 10 GROUP BY DisplayName, Users.Id ORDER BY Score DESC