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