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