Q&A about the site for users of the Magento e-Commerce platform
-- Top users from China SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS Link, DisplayName, Reputation FROM Users WHERE (LOWER(Location) LIKE '%india%' OR UPPER(Location) LIKE '%INDIA%' OR Location LIKE 'Bangalore' ) and reputation > 2194 ORDER BY Reputation DESC;