Database: address_1
Question: How many cities are there in each country?
SQL:
SELECT country ,  count(*) FROM City GROUP BY country