Q&A for meta-discussion of the Stack Exchange family of Q&A websites
-- List of Users in the United Kingdom
ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#],
Id AS [User Link],
lower(location) like lower('united kingdom')
or lower(location) like ('% uk')
or lower(location) LIKE '%aberdeen%' --includes Aberdeenshire
-- Enter dummy if not required
lower(location) LIKE '%xaberdeen, id%'
--or lower(location) LIKE '%aberdeen, sd%'
order by location asc -- to pick out incorrect results