SCHEMA:
CREATE TABLE airport (country VARCHAR)
User Question:
how many airports are there in each country?


SELECT COUNT(*), country FROM airport GROUP BY country