What are all the information about the pilots?
select * from pilot
What about the fleet series?
select fleet_series from aircraft
Show all the flying records with the pilot names and the aircraft's sleet series.
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
Now show those results in ascending order of the pilot age.
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.age
What about in ascending order of the pilot rank?
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