DROP TABLE Flights;

CREATE TABLE Flights(
  airline CHAR(2),
  cityfrom VARCHAR2(10),
  cityto VARCHAR2(10),
  fee NUMBER,
  departs NUMBER,
  arrives NUMBER);

INSERT INTO Flights VALUES('UA', 'SF','DEN', 1000, 930,1230);
INSERT INTO Flights VALUES('AA', 'SF','DAL', 10000, 900,1430);
INSERT INTO Flights VALUES('UA','DEN','CHI', 500, 1500,1800);
INSERT INTO Flights VALUES('AA','DEN','DAL', 2000, 1400,1700);
INSERT INTO Flights VALUES('AA','DAL','CHI', 600, 1530,1730);
INSERT INTO Flights VALUES('AA','DAL', 'NY', 2000, 1500,1930);
INSERT INTO Flights VALUES('AA','CHI', 'NY', 3000, 1900,2200);
INSERT INTO Flights VALUES('UA','CHI', 'NY', 2000, 1830,2130);
INSERT INTO Flights VALUES('LH', 'CHI', 'DEN', 2000, 1900, 2100);

COMMIT;

SELECT * FROM Flights;