Croatian SO Users By Reputation

1

Please login or register to vote for this query.

(click on this box to dismiss)

Open Data

Q&A for developers and researchers interested in open data

SELECT

    ROW_NUMBER() OVER (ORDER BY Reputation DESC) AS 'ID', 
    --Id [User Link], 
    DisplayName AS 'Name',
    Reputation AS 'Rep',
    UpVotes AS 'Up',
    DownVotes AS 'Down',
    Views AS 'Views',
    CreationDate AS 'Since',
    LastAccessDate AS 'Last Seen',
    Location AS 'Location',
    Id AS 'SO ID',
    AccountId AS 'SE ID'

FROM Users

WHERE LOWER(Location) LIKE '%croatia%' 
OR LOWER(Location) LIKE '%hrvatska%'

ORDER by Reputation DESC, LastAccessDate DESC, CreationDate DESC

Enter Parameters

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