0

Please login or register to vote for this query.

(click on this box to dismiss)

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;

view current version

edited apr 16 15

created apr 16 15 anonymous