CREATE TABLE airports (name VARCHAR2, city VARCHAR2, apid VARCHAR2)
CREATE TABLE routes (src_apid VARCHAR2)

Find the name and city of the airport which is the source for the most number of flight routes.
SELECT T1.name, T1.city, T2.src_apid FROM airports AS T1 JOIN routes AS T2 ON T1.apid = T2.src_apid GROUP BY T2.src_apid ORDER BY COUNT(*) DESC LIMIT 1
SELECT "T1"."name", "T1"."city", "T2"."src_apid" FROM "airports" "T1" JOIN "routes" "T2" ON "T1"."apid" = "T2"."src_apid" GROUP BY "T2"."src_apid" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY