Q&A for designers and users of artificial or invented languages, consciously developed instead of having developed naturally
SELECT seqnum as 'Position'
FROM (SELECT ROW_NUMBER() OVER (ORDER BY Reputation DESC) AS seqnum,
Id AS [UserId],
WHERE LOWER(Location) LIKE '%spain%'
WHERE UserId = 826194
SELECT COUNT(*) as 'Users from Spain:'
LOWER(Location) LIKE '%spain%'