Give the country id and corresponding count of cities in each country.
SELECT country_id ,  COUNT(*) FROM locations GROUP BY country_id
country id refers to country_id; count of cities in each country refers to COUNT(*);