CREATE TABLE routes (rid DECIMAL, dst_apid DECIMAL, dst_ap TEXT, src_apid DECIMAL, src_ap TEXT, alid DECIMAL, airline TEXT, codeshare TEXT)
CREATE TABLE airports (apid DECIMAL, name TEXT, city TEXT, country TEXT, x DECIMAL, y DECIMAL, elevation DECIMAL, iata TEXT, icao TEXT)
CREATE TABLE airlines (alid DECIMAL, name TEXT, iata TEXT, icao TEXT, callsign TEXT, country TEXT, active TEXT)

For each airport name, how many routes start at that airport?
SELECT COUNT(*), T1.name FROM airports AS T1 JOIN routes AS T2 ON T1.apid = T2.src_apid GROUP BY T1.name
SELECT COUNT(*), "T1"."name" FROM "airports" AS "T1" JOIN "routes" AS "T2" ON "T1"."apid" = "T2"."src_apid" GROUP BY "T1"."name"