Database: flight_4
Question: What is the number of airports per country, ordered from most to least?
SQL:
SELECT count(*) ,  country FROM airports GROUP BY country ORDER BY count(*) DESC