Table schema:
CREATE TABLE airports (country VARCHAR)

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