How many airports are there per country? Order the countries by decreasing number of airports.
CREATE TABLE airports (
    country VARCHAR
)
SELECT COUNT(*), country FROM airports GROUP BY country ORDER BY COUNT(*) DESC
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many airports are there per country? Order the countries by decreasing number of airports. ### Input: CREATE TABLE airports (
    country VARCHAR
) ### Response: SELECT COUNT(*), country FROM airports GROUP BY country ORDER BY COUNT(*) DESC