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.
Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
-- 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'%Canada%' AND Location NOT like N'%[ ,]WA%' ORDER BY reputation DESC