Give the country id and corresponding count of cities in each country.
select country_id, count(*) from locations group by country_id