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 from Users