Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
SELECT seqnum as 'Position'
FROM (SELECT ROW_NUMBER() OVER (ORDER BY Reputation DESC) AS seqnum,
Id AS [UserId],
WHERE LOWER(Location) LIKE '%romania%'
WHERE UserId = 6729397
SELECT COUNT(*) as 'Users from Romania:'
LOWER(Location) LIKE '%romania%'