CREATE TABLE pilot (pilot_id NUMBER, pilot_name CLOB, rank NUMBER, age NUMBER, nationality CLOB, position CLOB, join_year NUMBER, team CLOB)
CREATE TABLE pilot_record (record_id NUMBER, pilot_id NUMBER, aircraft_id NUMBER, date CLOB)
CREATE TABLE aircraft (aircraft_id NUMBER, order_year NUMBER, manufacturer CLOB, model CLOB, fleet_series CLOB, powertrain CLOB, fuel_propulsion CLOB)

Show the names of pilots and fleet series of the aircrafts they have flied with in ascending order of the rank of the pilot.
SELECT T3.pilot_name, T2.fleet_series FROM pilot_record AS T1 JOIN aircraft AS T2 ON T1.aircraft_id = T2.aircraft_id JOIN pilot AS T3 ON T1.pilot_id = T3.pilot_id ORDER BY T3.rank
SELECT "T3"."pilot_name", "T2"."fleet_series" FROM "pilot_record" "T1" JOIN "aircraft" "T2" ON "T1"."aircraft_id" = "T2"."aircraft_id" JOIN "pilot" "T3" ON "T1"."pilot_id" = "T3"."pilot_id" ORDER BY "T3"."rank"