Find the number of routes and airport name for each source airport, order the results by decreasing number of routes.
CREATE TABLE airports (
    name VARCHAR,
    apid VARCHAR
)

CREATE TABLE routes (
    src_apid VARCHAR
)
SELECT COUNT(*), T1.name FROM airports AS T1 JOIN routes AS T2 ON T1.apid = T2.src_apid GROUP BY T1.name 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: Find the number of routes and airport name for each source airport, order the results by decreasing number of routes. ### Input: CREATE TABLE airports (
    name VARCHAR,
    apid VARCHAR
)

CREATE TABLE routes (
    src_apid VARCHAR
) ### Response: SELECT COUNT(*), T1.name FROM airports AS T1 JOIN routes AS T2 ON T1.apid = T2.src_apid GROUP BY T1.name ORDER BY COUNT(*) DESC