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
or lower(location) LIKE '%aberystwyth%'
-- Enter dummy if not required
lower(location) LIKE '%aberdeen, id%'
or lower(location) LIKE '%aberdeen, sd%'
order by location asc -- to pick out incorrect results