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 about the site for enthusiasts and scholars of mythology and folklore
SELECT TOP 100
Id as [User Id],
Location like N'%Thess%'
OR Location like N'%Greece%'
OR Location like N'%Gr'
OR Location like N'%Patra%'
OR (Location like N'%Athens%' AND Location NOT like N'%GA%')