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

For the airline ids with the top 10 most routes operated, what are their names?
SELECT T1.name, T2.alid FROM airlines AS T1 JOIN routes AS T2 ON T1.alid = T2.alid GROUP BY T2.alid ORDER BY COUNT(*) DESC LIMIT 10
SELECT "T1"."name", "T2"."alid" FROM "airlines" "T1" JOIN "routes" "T2" ON "T1"."alid" = "T2"."alid" GROUP BY "T2"."alid" ORDER BY COUNT(*) DESC FETCH FIRST 10 ROWS ONLY