-- QUERY 1: CREATE TABLE FLIGHT ( CRAFT_CODE VARCHAR(30), SOURCE VARCHAR(30), DESTINATION VARCHAR(30) )

INSERT INTO FLIGHT VALUES ('AI01', 'HYB', 'NYC'), ('AI03', 'HYB', 'LSA'), ('AI05', 'HYB', 'LSA')

-- QUERY 2: create table Reservation ( Aircraft_Code varchar(10), No_of_Seats int, Class_Code varchar(10) )

INSERT INTO Reservation VALUES ('AI01', 11, 'ECO'), ('AI02', 22, 'ECO') INSERT INTO Reservation VALUES ('AI03', 33, 'ECO'), ('AI04', 44, 'BIZ') INSERT INTO Reservation VALUES ('AI01', 23, 'ECO'), ('AI02', 23, 'BIZ') INSERT INTO Reservation VALUES ('AI01', 21, 'BIZ'), ('AI02', 21, 'BIZ')

-- TASK 1: HOW TO REPORT LIST OF ALL FLIGHTS WITH 0 OR NO RESERVATIONS ? -- TASK 2: HOW TO REPORT LIST OF ALL FLIGHTS WITH ATLEAST 1 RESERVATION ? -- TASK 3: HOW TO REPORT LIST OF ALL RESERVATIONS WITH & WITHOUT FLIGHTS ? -- TASK 4: HOW TO REPORT LIST OF ALL RESERVATIONS WITH MAXIMUM NUMBER OF SEATS? -- TASK 5: HOW TO REPORT LIST OF ALL FLIGHTS WITH SUCH RESERVATIONS FOR MAXIMUM NUMBER OF SEATS?