1

Please login or register to vote for this query.

(click on this box to dismiss)

Top Iranian users in StackOverflow, the other select queries have many issues, one of them that is suggested by Google select some users of Tirana from Albania. But my query works well and has a limitation to show users more than 999 reputations.

Q&A for people interested in the history and origins of science and mathematics

-- top users: Iran
-- List of Iranian-based users by reputation score. 


SELECT
    ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
    Id AS [User Link], 
    Reputation,
    Location
FROM
    Users
WHERE
    LOWER(Location) LIKE '%, iran%'
    OR LOWER(Location) = 'iran'
    AND Reputation >= 1000
ORDER BY
    Reputation DESC;

fork query

edited mar 14 20 Amer.Lotfi.Orimi

created oct 5 12 Champ