0

Please login or register to vote for this query.

(click on this box to dismiss)

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
    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%'
 --   OR UPPER(USERS.Location) LIKE '%IRAN%')
 --   AND UPPER(POSTS.Tags LIKE '%LINUX%';
-- ORDER BY
  -- score DESC;

fork query

edited may 18 anonymous

created oct 5 12 Champ