Q&A for community managers, administrators, and moderators
select Reputation, DisplayName, ROW_NUMBER() over ( order by Reputation desc) FROM Users Where LOWER(Location) IN ('united kingdom') and Reputation > 1000 order by Reputation desc