Location Cleanup

0

Please login or register to vote for this query.

(click on this box to dismiss)

Tridion Meta

Q&A about the site for Tridion developers and administrators

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results