SELECT count(*) ,  country FROM airport GROUP BY country
how many airports are there in each country?
SELECT count ( * ) , country FROM airport GROUP BY country
select count ( * ) , country from airport group by country
how many airports are there in each country ?