CREATE TABLE Flights (flight INTEGER, start TEXT, finish TEXT, dep TEXT, arr TEXT, aircraft TEXT);
INSERT INTO Flights VALUES (001, 'JFK', 'LAX', '0730', '1230', 'B757');
INSERT INTO Flights VALUES (002, 'LAX', 'JFK', '1630', '0330', 'B757');
INSERT INTO Flights VALUES (003, 'BOS', 'NAT', '1400', '1600', 'A730');
INSERT INTO Flights VALUES (004, 'NAT', 'CHI', '1900', '2200', 'A730');
INSERT INTO Flights VALUES (005, 'CHI', 'BOS', '0800', '1100', 'A730');
INSERT INTO Flights VALUES (006, 'LAX', 'DEN', '1200', '1500', 'C130');
INSERT INTO Flights VALUES (007, 'DEN', 'SEA', '1800', '2200', 'C130');
INSERT INTO Flights VALUES (008, 'SEA', 'LAX', '0600', '0900', 'C130');
CREATE TABLE Aircraft (aircraft TEXT, maker TEXT, seats INTEGER, built INTEGER, service TEXT);
INSERT INTO Aircraft VALUES ('A730', 'Airbus', 180, 2011, '06/01/2019');
INSERT INTO Aircraft VALUES ('B757', 'Boeing', 210, 2015, '10/15/2018');
INSERT INTO Aircraft VALUES ('C130', 'Embraer', 30, 2006, '08/20/2019');
CREATE TABLE Seats (aircraft TEXT, row INTEGER, seat TEXT, type TEXT, class TEXT);
INSERT INTO Seats VALUES ('A730', 1, 'A', 'Window', 'First');
INSERT INTO Seats VALUES ('A730', 1, 'C', 'Aisle', 'First');
INSERT INTO Seats VALUES ('A730', 2, 'A', 'Window', 'First');
INSERT INTO Seats VALUES ('A730', 2, 'C', 'Aisle', 'First');
INSERT INTO Seats VALUES ('B757', 1, 'A', 'Window', 'Second');
INSERT INTO Seats VALUES ('B757', 1, 'B', 'Middle', 'Second');
INSERT INTO Seats VALUES ('B757', 1, 'C', 'Aisle', 'Second');
INSERT INTO Seats VALUES ('C130', 6, 'A', 'Exit', 'Second');
CREATE TABLE Bookings (flight INTEGER, date TEXT, customer TEXT, row INTEGER, seat TEXT, booking INTEGER);
INSERT INTO Bookings VALUES (001, '10/01/19', 'Child, J.', 12, 'A', 83294);
INSERT INTO Bookings VALUES (001, '10/01/19', 'Ray, R.', 12, 'B', 83295);
INSERT INTO Bookings VALUES (001, '10/01/19', 'Maddow, R.', 25, 'F', 37543);
INSERT INTO Bookings VALUES (001, '10/01/19', 'Lynch, J.', 27, 'D', 93557);
INSERT INTO Bookings VALUES (002, '10/01/19', 'Smith, S.', 1, 'A', 21324);
INSERT INTO Bookings VALUES (002, '10/01/19', 'Maddow, R.', 25, 'F', 70833);
INSERT INTO Bookings VALUES (002, '10/01/19', 'Lynch, J.', 27, 'D', 41412);
INSERT INTO Bookings VALUES (003, '10/01/19', 'Friedan, B.', 18, 'C', 63904);
INSERT INTO Bookings VALUES (003, '10/01/19', 'Steinem, G.', 18, 'D', 63905);
INSERT INTO Bookings VALUES (003, '10/01/19', 'McCartney, K.', 11, 'E', 32007);
INSERT INTO Bookings VALUES (004, '10/01/19', 'Wambach, A.', 6, 'C', 88224);
INSERT INTO Bookings VALUES (004, '10/01/19', 'Hamm, M.', 6, 'B', 88225);
INSERT INTO Bookings VALUES (004, '10/01/19', 'Rapinoe, M.', 6, 'A', 88226);
INSERT INTO Bookings VALUES (001, '10/02/19', 'Maddow, R.', 25, 'F', 86021);
INSERT INTO Bookings VALUES (001, '10/02/19', 'Lynch, J.', 27, 'D', 57342);