Q&A about the site for administrators, end users, developers and designers for Craft CMS
select T.Country, count(*) from(
WHEN UPPER(Location) LIKE '%INDIA%' THEN 'India'
WHEN UPPER(Location) LIKE '%UK%' THEN 'United Kingdom'
END AS Country
) AS T
group by T.Country
order by count(*) desc