TOP 100 users from Greece

0

Please login or register to vote for this query.

(click on this box to dismiss)

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.

スタック・オーバーフローMeta

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

-- 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 as [User Link],
   DisplayName,
   Reputation,
   WebsiteUrl,
   Location
FROM
   Users
WHERE
   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%')
ORDER BY
   reputation DESC

Enter Parameters

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