What is the name of the aircraft that was on flight number 99?
CREATE TABLE employee (
    eid number,
    name text,
    salary number
)

CREATE TABLE aircraft (
    aid number,
    name text,
    distance number
)

CREATE TABLE flight (
    flno number,
    origin text,
    destination text,
    distance number,
    departure_date time,
    arrival_date time,
    price number,
    aid number
)

CREATE TABLE certificate (
    eid number,
    aid number
)
SELECT T2.name FROM flight AS T1 JOIN aircraft AS T2 ON T1.aid = T2.aid WHERE T1.flno = 99
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: What is the name of the aircraft that was on flight number 99? ### Input: CREATE TABLE employee (
    eid number,
    name text,
    salary number
)

CREATE TABLE aircraft (
    aid number,
    name text,
    distance number
)

CREATE TABLE flight (
    flno number,
    origin text,
    destination text,
    distance number,
    departure_date time,
    arrival_date time,
    price number,
    aid number
)

CREATE TABLE certificate (
    eid number,
    aid number
) ### Response: SELECT T2.name FROM flight AS T1 JOIN aircraft AS T2 ON T1.aid = T2.aid WHERE T1.flno = 99