How many airports are there per country? Order the countries by decreasing number of airports.
CREATE TABLE airports (country VARCHAR)
[SQL] SELECT COUNT(*), country FROM airports GROUP BY country ORDER BY COUNT(*) DESC [/SQL]