Top Iranian users in StackOverFlow

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow Meta en español

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

-- 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.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%';

Enter Parameters

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