Q&A about the site for science fiction and fantasy enthusiasts
-- Top Users by Country -- Created by samliew (http://stackoverflow.com/users/584192/samuel-liew) SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], users.id AS [User Link], Reputation, Tags FROM posts left join users on OwnerUserId = users.id WHERE LOWER(Location) LIKE LOWER('%jordan%') ORDER BY Reputation DESC;