Database: flight_4
Question: How many airports are there per country? Order the countries by decreasing number of airports.
SQL:
SELECT count(*) ,  country FROM airports GROUP BY country ORDER BY count(*) DESC