SELECT count(*) ,  country FROM airports GROUP BY country ORDER BY count(*) DESC
How many airports are there per country? Order the countries by decreasing number of airports.
SELECT count ( * ) , country FROM airports GROUP BY country ORDER BY count ( * ) DESC
select count ( * ) , country from airports group by country order by count ( * ) desc
How many airports are there per country ? Order the countries by decreasing number of airports .