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

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