Lists the top 50 users (ranked by reputation) that are located in Calicut/Kozhikode, Kerala, India according to their profile information. Thanks to http://data.stackexchange.com/stackoverflow/qe/1157/top-100-users-from-greece
Q&A for Drupal developers and administrators
-- TOP 50 users from INDIA -- Lists the top 50 users (ranked by reputation) that are located in Calicut/Kozhikode, Kerala, India according to their profile information. -- Thanks to http://data.stackexchange.com/stackoverflow/qe/1157/top-100-users-from-greece SELECT TOP 150 Id, DisplayName, Reputation, WebsiteUrl, Location FROM Users WHERE Location like N'%India%' --OR Location like N'%Kozhi%' --OR Location like N'%Kerala%' ORDER BY reputation DESC