1

Please login or register to vote for this query.

(click on this box to dismiss)

List of users in Saskatoon, Canada ordered by reputation.

Q&A for professional and enthusiast programmers

-- List of users in Saskatoon (Canada) ordered by reputation.

SELECT 
    ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
    Id AS [User Link], 
    Reputation 
FROM 
    Users 
WHERE 
    LOWER(Location) LIKE '%saskatoon%' 
ORDER BY 
    Reputation DESC;

fork query

edited may 16 13

created oct 6 12 Jesse Webb