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
[{'COUNTRY_ID': '"', 'COUNT(*)': 1}, {'COUNTRY_ID': 'AU', 'COUNT(*)': 1}, {'COUNTRY_ID': 'BR', 'COUNT(*)': 1}, {'COUNTRY_ID': 'CA', 'COUNT(*)': 2}, {'COUNTRY_ID': 'CH', 'COUNT(*)': 2}, {'COUNTRY_ID': 'CN', 'COUNT(*)': 1}, {'COUNTRY_ID': 'DE', 'COUNT(*)': 1}, {'COUNTRY_ID': 'IN', 'COUNT(*)': 1}, {'COUNTRY_ID': 'IT', 'COUNT(*)': 2}, {'COUNTRY_ID': 'JP', 'COUNT(*)': 2}, {'COUNTRY_ID': 'NL', 'COUNT(*)': 1}, {'COUNTRY_ID': 'Ox', 'COUNT(*)': 1}, {'COUNTRY_ID': 'SG', 'COUNT(*)': 1}, {'COUNTRY_ID': 'UK', 'COUNT(*)': 2}, {'COUNTRY_ID': 'US', 'COUNT(*)': 4}]