0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

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


SELECT TOP(10)
    --ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
    UserS.Id AS [User Link],
    POSTS.Id AS [Post Link],
    POSTS.Score as score
FROM
    POSTS JOIN USERS ON POSTS.OwnerUserId=USERS.ID
WHERE
    LOWER(USERS.Location) LIKE '%iran%'
ORDER BY
    score DESC
--
 --   OR UPPER(USERS.Location) LIKE '%IRAN%')
 --   AND UPPER(POSTS.Tags LIKE '%LINUX%';

fork query

created may 18 jon.doe39005