Top 100 users from Vancouver, BC

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 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

Drones and Model Aircraft Meta

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

-- Top 100 users from Vancouver, BC
-- 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.

SELECT TOP 100
   Id,
   DisplayName,
   Reputation,
   WebsiteUrl,
   Location
FROM
   Users
WHERE
   Location like N'%Vancouver%' AND Location NOT like N'%[ ,]WA%'
ORDER BY
   reputation DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results