how many airports are there in each country?
SELECT count(*) ,  country FROM airport GROUP BY country
SELECT count(*) ,  country FROM airport GROUP BY country
[{'count(*)': 1, 'Country': 'Belgium'}, {'count(*)': 1, 'Country': 'Denmark'}, {'count(*)': 1, 'Country': 'Iceland'}, {'count(*)': 1, 'Country': 'Netherlands'}, {'count(*)': 1, 'Country': 'Norway'}, {'count(*)': 1, 'Country': 'Spain'}, {'count(*)': 3, 'Country': 'United States'}]