Lists the top 100 users (ranked by reputation) that are located in Italy according to their profile information. Based on http://data.stackexchange.com/stackoverflow/s/1166/top-100-users-from-vancouver
Q&A for Muslims, experts in Islam, and those interested in learning more about Islam
-- Top 100 users from Italy -- Lists the top 100 users (ranked by reputation) that are located in Vancouver according to their profile information. Tries to filter out those in Vancouver, Washington. -- -- Based on http://data.stackexchange.com/stackoverflow/s/1166/top-100-users-from-vancouver SELECT TOP 1000 Id as [User Link], DisplayName, Reputation, WebsiteUrl, Location FROM Users WHERE Location like N'Ital%' ORDER BY reputation DESC