Q&A for professionals, academics, and students working within the systems development life cycle
-- Top Arab Users SELECT ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS [User Link], Reputation, Location, CreationDate, LastAccessDate, Views FROM Users WHERE LOWER(Location) like '%egypt%' or LOWER(Location) like '%algeria%' or LOWER(Location) like '%iraq%' or LOWER(Location) like '%sudan%' or LOWER(Location) like '%morocco%' or LOWER(Location) like '%saudi%' or LOWER(Location) like '%yemen%' or LOWER(Location) like '%syria%' or LOWER(Location) like '%tunis%' or LOWER(Location) like '%somalia%' or LOWER(Location) like '%emirat%' or LOWER(Location) like '%jordan%' or LOWER(Location) like '%libya%' or LOWER(Location) like '%palestine%' or LOWER(Location) like '%lebanon' or LOWER(Location) like '%oman' or LOWER(Location) like '%kuwait%' or LOWER(Location) like '%mauritania%' or LOWER(Location) like '%qatar%' or LOWER(Location) like '%bahrain%' or LOWER(Location) like '%djibouti%' or LOWER(Location) like '%comoros%' ORDER BY Reputation DESC;