human
Schema:
aircraft (Aircraft_ID, Order_Year, Manufacturer, Model, Fleet_Series, Powertrain, Fuel_Propulsion)
pilot (Pilot_ID, Pilot_name, Rank, Age, Nationality, Position, Join_Year, Team)
pilot_record (Record_ID, Pilot_ID, Aircraft_ID, Date)
Please answer with SQL.
assistant
Sure, I understand.
human
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?
assistant
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;
human
What are each of those pilots' nationalities? | Do you want to konw Pilot name and related pilots' nationalities? | Yes, please.
assistant
SELECT Pilot_name , Nationality FROM pilot;
human
What kind of fuel propulsion do these pilots' aircrafts use?
assistant
SELECT distinct ( Fuel_Propulsion ) FROM aircraft ;