display the country ID and number of cities for each country.
select country_id, count(*) from locations group by country_id