Q&A for professional and enthusiast programmers
select row_number()over(order by reputation desc) , Reputation, DisplayName, CreationDate, LastAccessDate, Views, Upvotes, Downvotes, ProfileImageUrl, AboutMe, AccountId, Id from users where lower(location)like'%singapore%'order by reputation desc