how many airports are in the record?
select count(*) from airports
how many airports are in each country?
select count(*), country from airports group by country
order them by number of airports in decreasing order.
select count(*), country from airports group by country order by count(*) desc