0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited apr 16 13 anonymous

created may 15 11 grzegorz.oledzki