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
Preguntas y respuestas para programadores y profesionales de la informática
-- 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 20 Id, DisplayName, Reputation, WebsiteUrl, Location FROM Users WHERE Location like N'%Coimbatore%' --OR Location like N'%Kozhi%' --OR Location like N'%Kerala%' ORDER BY reputation DESC