What are all the information about the pilots?
select * from pilot
What about the fleet series?
select fleet_series from aircraft
How about the aircraft models?
select model from aircraft
Show all the flying records with the pilot names and the aircraft's models.
select t3.pilot_name, t2.model 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