Show the names of pilots and models of aircrafts they have flied with.
CREATE TABLE pilot (
    Pilot_name VARCHAR,
    Pilot_ID VARCHAR
)

CREATE TABLE aircraft (
    Model VARCHAR,
    Aircraft_ID VARCHAR
)

CREATE TABLE pilot_record (
    Aircraft_ID VARCHAR,
    Pilot_ID VARCHAR
)
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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Show the names of pilots and models of aircrafts they have flied with. ### Input: CREATE TABLE pilot (
    Pilot_name VARCHAR,
    Pilot_ID VARCHAR
)

CREATE TABLE aircraft (
    Model VARCHAR,
    Aircraft_ID VARCHAR
)

CREATE TABLE pilot_record (
    Aircraft_ID VARCHAR,
    Pilot_ID VARCHAR
) ### Response: 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