How many airports are there per city in the United States? Order the cities by decreasing number of airports.
CREATE TABLE routes (
    rid number,
    dst_apid number,
    dst_ap text,
    src_apid number,
    src_ap text,
    alid number,
    airline text,
    codeshare text
)

CREATE TABLE airports (
    apid number,
    name text,
    city text,
    country text,
    x number,
    y number,
    elevation number,
    iata text,
    icao text
)

CREATE TABLE airlines (
    alid number,
    name text,
    iata text,
    icao text,
    callsign text,
    country text,
    active text
)
SELECT COUNT(*), city FROM airports WHERE country = 'United States' GROUP BY city 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 city in the United States? Order the cities by decreasing number of airports. ### Input: CREATE TABLE routes (
    rid number,
    dst_apid number,
    dst_ap text,
    src_apid number,
    src_ap text,
    alid number,
    airline text,
    codeshare text
)

CREATE TABLE airports (
    apid number,
    name text,
    city text,
    country text,
    x number,
    y number,
    elevation number,
    iata text,
    icao text
)

CREATE TABLE airlines (
    alid number,
    name text,
    iata text,
    icao text,
    callsign text,
    country text,
    active text
) ### Response: SELECT COUNT(*), city FROM airports WHERE country = 'United States' GROUP BY city ORDER BY COUNT(*) DESC