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 enthusiasts and power users of the Android operating system
-- 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 100 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