Q&A for scientific skepticism
select distinct Location, case when Location like'%USA%' then 'United States' when Location like'%UK%' then 'United Kingdom' end usa_uk from Users