instruction: Top Users in New Zealand. Created by samliew (http://stackoverflow.com/users/584192/samuel-liew)
response: SELECT ROW_NUMBER() OVER (ORDER BY Reputation DESC) AS "#", Id AS "user_link", DisplayName, Reputation, Location FROM Users WHERE LOWER(Location) LIKE LOWER('%New Zealand%') ORDER BY Reputation DESC