CREATE TABLE pilot (Pilot_name VARCHAR2, Pilot_ID VARCHAR2)
CREATE TABLE aircraft (Model VARCHAR2, Aircraft_ID VARCHAR2)
CREATE TABLE pilot_record (Aircraft_ID VARCHAR2, Pilot_ID VARCHAR2)

Show the names of pilots and models of aircrafts they have flied with.
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
SELECT "T3"."Pilot_name", "T2"."Model" FROM "pilot_record" "T1" JOIN "aircraft" "T2" ON "T1"."Aircraft_ID" = "T2"."Aircraft_ID" JOIN "pilot" "T3" ON "T1"."Pilot_ID" = "T3"."Pilot_ID"