Q&A for people looking to bypass life's everyday problems with simple tricks
select distinct Location, case when Location like'%USA%' then 'United States' when Location like'%UK%' then 'United Kingdom' end usa_uk from Users