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 scientific skepticism
-- 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'%Pit%' OR Location like N'%PA%' ORDER BY reputation DESC