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 professionals in medical and allied health fields, students of those professions, related academics, and others with a sound understanding of medicine and healthcare-related sciences
-- 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 1100 Id, DisplayName, Reputation, WebsiteUrl, Location FROM Users WHERE Location like N'%Iran%' --OR Location like N'%Kozhi%' --OR Location like N'%Kerala%' ORDER BY reputation DESC