Q&A for community managers, administrators, and moderators
select Reputation, DisplayName, Id, ROW_NUMBER() over ( order by Reputation desc) FROM Users WHERE LOWER(Location) IN ('hong kong') AND Reputation > 1000 AND Id = 2952180 order by Reputation desc