CREATE TABLE pilot_record (Aircraft_ID VARCHAR(255), Pilot_ID VARCHAR(255)); CREATE TABLE pilot (Pilot_name VARCHAR(255), Pilot_ID VARCHAR(255)); CREATE TABLE aircraft (Model VARCHAR(255), Aircraft_ID VARCHAR(255))
Show the names of pilots and models of aircrafts they have flied with.
    
SQL: 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