Location Cleanup

select Location, Cnt,
case
when Location like '%USA%' then 'USA'
when Location like '%United States%' then 'USA'
end as CleanedLocation
from
(select Location, count(Location) as Cnt from Users group by Location) q1
order by Cnt desc