Q&A about the site for music historians, critics, and fans
SELECT Top ##Top## ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], DisplayName, WebsiteUrl, Location, Age, Reputation, Id FROM Users WHERE LOWER(Location) LIKE LOWER('%##FullCountryName##%') ORDER BY Reputation DESC;