Q&A for science fiction and fantasy enthusiasts
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