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 about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure
-- 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 --OR Location like N'%Kozhi%' --OR Location like N'%Kerala%' SELECT TOP 1000 Id, DisplayName, Reputation, WebsiteUrl, Location FROM Users WHERE Location like N'%gujarat%' ORDER BY reputation DESC