Q&A for those using, extending or developing Emacs
select distinct Location, case when Location like'USA' then 'United States' when Location like'UK' then 'United Kingdom' end usa_uk from Users