How many airports are there per country? Order the countries by decreasing number of airports.
create table airports (country varchar, PRIMARY KEY (country))
select count(*), country from airports group by country order by count(*) desc