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 builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors
SELECT TOP 100
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%')