0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for gardeners and landscapers

-- top users: Pune
-- List of Pune-based users by reputation score.
-- 
-- Stolen from http://data.stackexchange.com/meta/query/65964/top-users-singapore

SELECT
    ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
    Id AS [User Link], 
    Reputation, 
    AboutMe
FROM
    Users
WHERE
LOWER(Location) LIKE '%salt lake city%' and lower(AboutMe) LIKE '%c#%'
ORDER BY
    Reputation DESC;

fork query

edited apr 17 13 anonymous

created apr 5 12 Manishearth