Top 500 users from the Netherlands

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lists the top 500 users (ranked by reputation) that are located in the Netherlands based on their profile info

Spanish Language

Q&A for linguists, teachers, students and Spanish language enthusiasts in general wanting to discuss the finer points of the language

-- Top 500 users from the Netherlands
-- Lists the top 500 users (ranked by reputation) that are located in the Netherlands based on their profile info

SELECT TOP 500
   RANK() OVER 
   (ORDER BY Reputation DESC) AS 'Rank',
   Id as [User Link],
   Age,
   Reputation,
   WebsiteUrl,
   Location
FROM
   Users
WHERE
   Location like N'%Netherlands%' OR
   Location like N'%Holland%' OR
   Location like N'%Amsterdam%' OR
   (Location like N'%NL%' AND Location not like N'%finland%')
ORDER BY
   reputation DESC

Enter Parameters

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