Lists the top 100 users (ranked by reputation) that are located in Greece according to their profile information. A range of options is used to pinpoint members from Greece based on popular locations used.
Q&A for linguists, teachers, students and Spanish language enthusiasts in general wanting to discuss the finer points of the language
-- TOP 100 users from Greece -- Lists the top 100 users (ranked by reputation) that are located in Greece according to their profile information. -- A range of options is used to pinpoint members from Greece based on popular locations used. SELECT TOP 100 Id, DisplayName, Reputation, WebsiteUrl, Location FROM Users WHERE Location like N'%Scot%' OR Location like N'%Ecosse%' OR Location like N'%Glasgow' OR Location like N'%Edinburgh%' OR Location like N'%Dundee%' OR Location like N'%Stirling%' OR (Location like N'%Aberdeen%' AND Location NOT like N'%GA%') ORDER BY Location ASC