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