Database: address_1
Question: Show all countries and number of cities in each .
SQL:
select country ,  count(*) from city group by country