SELECT count(*) ,  country FROM airports GROUP BY country ORDER BY count(*) DESC
What is the number of airports per country, ordered from most to least?
SELECT count ( * ) , country FROM airports GROUP BY country ORDER BY count ( * ) DESC
select count ( * ) , country from airports group by country order by count ( * ) desc
What is the number of airports per country , ordered from most to least ?