Q&A for amateur radio enthusiasts
select Reputation, DisplayName, Id, ROW_NUMBER() over ( order by Reputation desc) FROM Users WHERE LOWER(Location) IN ('united kingdom') AND Reputation > 1000 order by Reputation desc