Can you please show the names of all pilots and fleet series of the aircrafts they have flown 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
Yes, please.
select pilot_name,nationality from pilot
What kind of fuel propulsion do these pilots' aircrafts use?
select distinct ( fuel_propulsion ) from aircraft