Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs
-- 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