I need SQL commands ONLY!!! This is the database: insert into airport values (\'
ID: 3859612 • Letter: I
Question
I need SQL commands ONLY!!!
This is the database:
insert into airport values ('FLG', 'Flagstaff, AZ', 6920, '6027741897','');
insert into airport values ('PHX', 'Phoenix, AZ', 1257, '6025831971','Air West');
insert into airport values ('MSP', 'Minneapolis, MN', 862, '6123782910','Northwest');
insert into airport values ('LAX', 'Los Angeles, CA', 37, '3102731846','');
insert into airport values ('SFO', 'San Francisco, CA', 78, '4158392371','');
insert into airport values ('IAH', 'Houston, TX', 5, '2816642000','Continental');
insert into airport values ('DFW', 'Dallas, TX', 210, '2146218044','American');
insert into airport values ('JFK', 'New York, NY', 43, '2106732145', 'United');
insert into airport values ('DTW', 'Detroit, MI', 23, '4158219000', 'American');
insert into airport values ('OIA', 'Orlando, FL', 20, '5183240912', 'TWA');
insert into airport values ('MIA', 'Miami, FL', 16, '7175203400', 'Grand Cayman');
insert into flight values (101, 'FLG', 'PHX', to_date('05:15:am','hh:mi:am'), to_date('06:20:am','hh:mi:am'),'S', 48.50, 200, 0);
insert into flight values (102, 'PHX', 'MSP', to_date('09:00:am','hh:mi:am'), to_date('01:00:pm','hh:mi:pm'),'L', 156.00, 1000,1);
insert into flight values (103, 'MSP', 'PHX', to_date('05:00:pm','hh:mi:am'), to_date('07:15:pm','hh:mi:am'),'D', 156.00, 1000, -1 );
insert into flight values (104, 'PHX', 'FLG', to_date('08:30:pm','hh:mi:am'), to_date('09:15:pm','hh:mi:am'),'S', 48.50, 200, 0);
insert into flight values (15, 'PHX', 'LAX', to_date('07:00:am','hh:mi:am'), to_date('07:20:am','hh:mi:am'),'B', 49.00, 400, -1);
insert into flight values (329, 'LAX', 'PHX', to_date('09:10:pm','hh:mi:am'), to_date('11:59:pm','hh:mi:am'), '', 49.00, 400, 1);
insert into flight values (40, 'PHX', 'LAX', to_date('10:25:pm','hh:mi:am'), to_date('10:42:pm','hh:mi:am'), '', 49.00, 400, -1);
insert into flight values (400, 'LAX', 'PHX', to_date('10:10:am','hh:mi:am'), to_date('12:59:pm','hh:mi:am'), '', 49.00, 400, 1);
insert into flight values (600, 'PHX', 'SFO', to_date('06:46:am','hh:mi:am'), to_date('07:50:am','hh:mi:am'),'B', 109.00, 750, -1);
insert into flight values (604, 'PHX', 'SFO', to_date('08:33:am','hh:mi:am'), to_date('09:43:am','hh:mi:am'),'B', 109.00, 750, -1);
insert into flight values (606, 'PHX', 'SFO', to_date('11:45:am','hh:mi:am'), to_date('12:50:pm','hh:mi:am'),'L', 109.00, 750, -1);
insert into flight values (198, 'LAX', 'SFO', to_date('11:20:pm','hh:mi:am'), to_date('01:40:am','hh:mi:am'), '', 69.00, 400, 1);
insert into flight values (298, 'PHX', 'LAX', to_date('05:00:am','hh:mi:am'), to_date('05:30:am','hh:mi:am'), '', 39.00, 400, -1);
insert into flight values (60, 'PHX', 'SFO', to_date('05:45:pm','hh:mi:am'), to_date('06:36:pm','hh:mi:am'),'S', 139.00, 750, -1);
insert into flight values (59, 'SFO', 'PHX', to_date('10:00:am','hh:mi:am'), to_date('11:30:am','hh:mi:am'),'S', 149.00, 750, 1);
insert into flight values (691, 'SFO', 'PHX', to_date('11:25:am','hh:mi:am'), to_date('01:04:pm','hh:mi:am'), '', 109.00, 750, 1);
insert into flight values (518, 'SFO', 'PHX', to_date('02:23:pm','hh:mi:am'), to_date('04:16:pm','hh:mi:am'), '', 109.00, 750, 1);
insert into flight values (1260, 'SFO', 'PHX',to_date('05:58:pm','hh:mi:am'), to_date('07:51:pm','hh:mi:am'),'D', 109.00, 750, 1);
insert into flight values (500, 'IAH', 'DFW', to_date('08:00:am','hh:mi:am'), to_date('08:55:am','hh:mi:am'), '', 79.00, 250, 0);
insert into flight values (501, 'DFW', 'IAH', to_date('09:05:am','hh:mi:am'), to_date('10:00:am','hh:mi:am'), '', 79.00, 250, 0);
insert into flight values (502, 'IAH', 'JFK', to_date('08:30:am','hh:mi:am'), to_date('12:30:pm','hh:mi:am'), 'B', 289.00, 1200, -1);
insert into flight values (503, 'JFK', 'IAH', to_date('01:25:pm','hh:mi:am'), to_date('03:30:pm','hh:mi:am'),'S', 289.00, 1200, 1);
insert into flight values (521, 'IAH', 'DTW', to_date('11:30:am','hh:mi:am'), to_date('01:30:pm','hh:mi:am'),'L', 218.00, 1000, 0);
insert into flight values (723, 'DTW', 'JFK', to_date('01:30:pm','hh:mi:am'), to_date('04:05:pm','hh:mi:am'),'S', 189.00, 1000, 1);
insert into pilots VALUES ('WRP', 'Pasewark, William B.', '523451784', '64 RHODA AVENUE',
'PHOENIX', 'AZ', '84326', 2500, '02-JUL-1958', '23-JUL-1993');
insert into pilots VALUES ('ELL', 'Leiss, Ernst L.', '234783222', '91 BEVERLY HILL RD',
'FLAGSTAFF', 'AZ', '85120', 2640, '12-SEP-1953', '21-JAN-1990');
insert into pilots VALUES ('SSM', 'Moore, Sharon S.', '452127055', '44 THORNHILL TRAIL',
'LOS ANGELES', 'CA', '92300', 3000, '03-SEP-1952', '20-DEC-1989');
insert into pilots VALUES ('RS', 'Scamell, Richard', '452094673', '1500 EAST RIVERSIDE',
'CUPERTINO', 'CA', '94212', 560, '13-FEB-1913', '20-MAY-1995');
insert into pilots values ('SL', 'Long, Stuart', '148434500', '3722 GEORGETOWN',
'DALLAS', 'TX', '75090', 3000, '12-OCT-1950', '03-JUN-1991');
insert into PILOTS values ('CG', 'Gladchuk, Chet', '210453278', '519 TALL OAKS DRIVE',
'HOUSTON', 'TX', '77024', 3150, '03-JUN-1951', '28-FEB-1993');
insert into PILOTS values ('KCH', 'Harris, Kenneth C.', '211463278', '519 GREEN OAKS DRIVE',
'HOUSTON', 'TX', '77004', 3150, '03-JUN-1970', '28-MAY-1993');
insert into pilots VALUES ('VIT', 'Tabor, Victor T.', '234651322', '891 BARONSHIRE',
'FLAGSTAFF', 'AZ', '85120', 2640, '12-SEP-1973', '21-JAN-1998');
insert into pilots VALUES ('ELG', 'Green, Edward L.', '234781000', '9211 CANYON HILL RD',
'FLAGSTAFF', 'AZ', '85120', 2640, '12-SEP-1963', '21-JAN-1989');
INSERT INTO EQUIP_TYPE VALUES (1026, 'BOE 727', 188, 1882, 3.4);
INSERT INTO EQUIP_TYPE VALUES (1194, 'DC 7', 282, 2340, 3.8);
INSERT INTO EQUIP_TYPE VALUES (1080, 'BOE 727', 188, 1882, 3.4);
INSERT INTO EQUIP_TYPE VALUES (1368, 'DC 7', 282, 2340, 3.8);
INSERT INTO EQUIP_TYPE VALUES (1081, 'BOE 727', 188, 1882, 3.4);
INSERT INTO EQUIP_TYPE VALUES (1345, 'BOE 737', 270, 2150, 4.1);
INSERT INTO EQUIP_TYPE VALUES (1253, 'BOE 747', 480, 2800, 3.6);
INSERT INTO EQUIP_TYPE VALUES (1489, 'CONCORDE', 350, 2750, 3.1);
INSERT INTO EQUIP_TYPE VALUES (1347, 'BOE 737', 270, 2150, 4.1);
INSERT INTO EQUIP_TYPE VALUES (1082, 'BOE 727', 188, 1882, 3.4);
INSERT INTO EQUIP_TYPE VALUES (1346, 'BOE 737', 270, 2150, 4.1);
INSERT INTO EQUIP_TYPE VALUES (1083, 'BOE 727', 188, 1882, 3.4);
INSERT INTO EQUIP_TYPE VALUES (1084, 'BOE 727', 188, 1882, 3.4);
INSERT INTO EQUIP_TYPE VALUES (1085, 'BOE 727', 188, 1882, 3.4);
insert into departures values ('15',' 01-APR-2006', 'WRP' , 1026);
insert into departures values ('15',' 28-JUN-2006', 'WRP' , 1026);
insert into departures values ('15',' 20-AUG-2006', 'WRP' , 1026);
insert into departures values ('40',' 28-JUN-2006', 'SL' , 1081);
insert into departures values ('40',' 29-JUN-2006', 'SL' , 1081);
insert into departures values ('40',' 20-AUG-2006', 'SL' , 1081);
insert into departures values ('40',' 21-AUG-2006', 'SL' , 1081);
insert into departures values ('40',' 21-SEP-2006', 'SL' , 1081);
insert into departures values ('40',' 22-SEP-2006', 'SL' , 1081);
insert into departures values ('40',' 23-SEP-2006', 'SL' , 1081);
insert into departures values ('40',' 29-SEP-2006', 'SL' , 1081);
insert into departures values ('60',' 19-APR-2006', 'ELL' , 1194);
insert into departures values ('60',' 04-JUN-2006', 'ELL' , 1194);
insert into departures values ('60',' 05-JUN-2006', 'ELL' , 1194);
insert into departures values ('60',' 08-JUN-2006', 'ELL' , 1194);
insert into departures values ('60',' 10-JUN-2006', 'ELL' , 1194);
insert into departures values ('60',' 20-JUN-2006', 'ELL' , 1194);
insert into departures values ('60',' 21-JUN-2006', 'ELL' , 1194);
insert into departures values ('60',' 29-JUL-2006', 'ELL' , 1194);
insert into departures values ('60',' 24-AUG-2006', 'ELL' , 1194);
insert into departures values ('60',' 25-SEP-2006', 'ELL' , 1194);
insert into departures values ('101',' 18-APR-2006', 'KCH' , 1253);
insert into departures values ('101',' 15-JUL-2006', 'KCH' , 1253);
insert into departures values ('101',' 29-SEP-2006', 'KCH' , 1253);
insert into departures values ('102',' 02-APR-2006', 'KCH' , 1253);
insert into departures values ('102',' 18-APR-2006', 'KCH' , 1253);
insert into departures values ('102',' 21-APR-2006', 'KCH' , 1253);
insert into departures values ('102',' 25-APR-2006', 'KCH' , 1253);
insert into departures values ('102',' 01-MAY-2006', 'KCH' , 1253);
insert into departures values ('102',' 18-MAY-2006', 'KCH' , 1253);
insert into departures values ('102',' 21-JUN-2006', 'KCH' , 1253);
insert into departures values ('102',' 24-AUG-2006', 'KCH' , 1253);
insert into departures values ('102',' 25-AUG-2006', 'KCH' , 1253);
insert into departures values ('103',' 02-APR-2006', 'KCH' , 1253);
insert into departures values ('103',' 19-APR-2006', 'KCH' , 1253);
insert into departures values ('103',' 21-APR-2006', 'KCH' , 1253);
insert into departures values ('103',' 22-APR-2006', 'KCH' , 1253);
insert into departures values ('103',' 23-APR-2006', 'KCH' , 1253);
insert into departures values ('103',' 29-APR-2006', 'KCH' , 1253);
insert into departures values ('103',' 05-MAY-2006', 'KCH' , 1253);
insert into departures values ('103',' 18-MAY-2006', 'KCH' , 1253);
insert into departures values ('103',' 21-JUN-2006', 'KCH' , 1253);
insert into departures values ('103',' 26-AUG-2006', 'KCH' , 1253);
insert into departures values ('103',' 28-AUG-2006', 'KCH' , 1253);
insert into departures values ('103',' 29-AUG-2006', 'KCH' , 1253);
insert into departures values ('104',' 13-MAY-2006', 'KCH' , 1253);
insert into departures values ('104',' 25-MAY-2006', 'KCH' , 1253);
insert into departures values ('104',' 02-JUN-2006', 'KCH' , 1253);
insert into departures values ('104',' 20-JUL-2006', 'KCH' , 1253);
insert into departures values ('104',' 23-JUL-2006', 'KCH' , 1253);
insert into departures values ('104',' 30-JUL-2006', 'KCH' , 1253);
insert into departures values ('104',' 26-SEP-2006', 'KCH' , 1253);
insert into departures values ('329',' 01-APR-2006', 'WRP' , 1026);
insert into departures values ('329',' 10-APR-2006', 'WRP' , 1026);
insert into departures values ('329',' 20-JUN-2006', 'WRP' , 1026);
insert into departures values ('329',' 23-AUG-2006', 'WRP' , 1026);
insert into departures values ('329',' 24-AUG-2006', 'WRP' , 1026);
insert into departures values ('329',' 25-AUG-2006', 'WRP' , 1026);
insert into departures values ('329',' 27-AUG-2006', 'WRP' , 1026);
insert into departures values ('329',' 28-AUG-2006', 'WRP' , 1026);
insert into departures values ('329',' 22-SEP-2006', 'WRP' , 1026);
insert into departures values ('400',' 20-AUG-2006', 'SL' , 1081);
insert into departures values ('400',' 21-AUG-2006', 'SL' , 1081);
insert into departures values ('400',' 23-AUG-2006', 'SL' , 1081);
insert into departures values ('400',' 28-AUG-2006', 'SL' , 1081);
insert into departures values ('400',' 21-SEP-2006', 'SL' , 1081);
insert into departures values ('400',' 23-SEP-2006', 'SL' , 1081);
insert into departures values ('400',' 25-SEP-2006', 'SL' , 1081);
insert into departures values ('500',' 02-JUN-2006', 'RS' , 1368);
insert into departures values ('500',' 18-JUN-2006', 'RS' , 1368);
insert into departures values ('500',' 01-SEP-2006', 'RS' , 1368);
insert into departures values ('501',' 05-JUN-2006', 'RS' , 1368);
insert into departures values ('501',' 07-JUN-2006', 'RS' , 1368);
insert into departures values ('501',' 22-JUN-2006', 'RS' , 1368);
insert into departures values ('501',' 29-JUN-2006', 'RS' , 1368);
insert into departures values ('501',' 08-SEP-2006', 'RS' , 1368);
insert into departures values ('501',' 09-SEP-2006', 'RS' , 1368);
insert into departures values ('503',' 28-APR-2006', 'ELG' , 1489);
insert into departures values ('503',' 29-APR-2006', 'ELG' , 1489);
insert into departures values ('503',' 23-JUL-2006', 'ELG' , 1489);
insert into departures values ('503',' 27-JUL-2006', 'ELG' , 1489);
insert into departures values ('503',' 29-JUL-2006', 'ELG' , 1489);
insert into departures values ('503',' 30-JUL-2006', 'ELG' , 1489);
insert into departures values ('518',' 29-APR-2006', 'CG' , 1345);
insert into departures values ('518',' 30-APR-2006', 'CG' , 1345);
insert into departures values ('518',' 30-MAY-2006', 'CG' , 1345);
insert into departures values ('518',' 28-JUN-2006', 'CG' , 1345);
insert into departures values ('518',' 29-JUN-2006', 'CG' , 1345);
insert into departures values ('518',' 29-SEP-2006', 'CG' , 1345);
insert into departures values ('521',' 21-APR-2006', 'CG' , 1085);
insert into departures values ('521',' 19-JUL-2006', 'CG' , 1085);
insert into departures values ('521',' 20-JUL-2006', 'CG' , 1085);
insert into departures values ('600',' 17-APR-2006', 'WRP' , 1347);
insert into departures values ('600',' 25-APR-2006', 'WRP' , 1347);
insert into departures values ('600',' 21-JUN-2006', 'WRP' , 1347);
insert into departures values ('600',' 16-JUL-2006', 'WRP' , 1347);
insert into departures values ('600',' 26-AUG-2006', 'WRP' , 1347);
insert into departures values ('600',' 25-SEP-2006', 'WRP' , 1347);
insert into departures values ('604',' 22-APR-2006', 'CG' , 1345);
insert into departures values ('604',' 24-APR-2006', 'CG' , 1345);
insert into departures values ('604',' 30-APR-2006', 'CG' , 1345);
insert into departures values ('604',' 25-AUG-2006', 'CG' , 1345);
insert into departures values ('604',' 22-SEP-2006', 'CG' , 1345);
insert into departures values ('606',' 20-APR-2006', 'SL' , 1081);
insert into departures values ('606',' 21-APR-2006', 'SL' , 1081);
insert into departures values ('606',' 25-APR-2006', 'SL' , 1081);
insert into departures values ('606',' 27-APR-2006', 'SL' , 1081);
insert into departures values ('606',' 17-MAY-2006', 'SL' , 1081);
insert into departures values ('606',' 21-JUN-2006', 'SL' , 1081);
insert into departures values ('606',' 15-JUL-2006', 'SL' , 1081);
insert into departures values ('691',' 24-APR-2006', 'WRP' , 1347);
insert into departures values ('691',' 29-APR-2006', 'WRP' , 1347);
insert into departures values ('691',' 13-MAY-2006', 'WRP' , 1347);
insert into departures values ('691',' 19-MAY-2006', 'WRP' , 1347);
insert into departures values ('691',' 02-JUN-2006', 'WRP' , 1347);
insert into departures values ('691',' 28-JUN-2006', 'WRP' , 1347);
insert into departures values ('691',' 19-JUL-2006', 'WRP' , 1347);
insert into departures values ('691',' 20-JUL-2006', 'WRP' , 1347);
insert into departures values ('691',' 23-JUL-2006', 'WRP' , 1347);
insert into departures values ('691',' 22-SEP-2006', 'WRP' , 1347);
insert into departures values ('723',' 22-APR-2006', 'CG' , 1085);
insert into departures values ('723',' 23-APR-2006', 'CG' , 1085);
insert into departures values ('723',' 24-APR-2006', 'CG' , 1085);
insert into departures values ('723',' 25-APR-2006', 'CG' , 1085);
insert into departures values ('723',' 20-JUL-2006', 'CG' , 1085);
insert into departures values ('723',' 21-JUL-2006', 'CG' , 1085);
insert into departures values ('723',' 26-JUL-2006', 'CG' , 1085);
insert into departures values ('723',' 29-JUL-2006', 'CG' , 1085);
insert into departures values ('1260',' 18-APR-2006', 'SL' , 1081);
insert into departures values ('1260',' 19-APR-2006', 'SL' , 1081);
insert into departures values ('1260',' 22-APR-2006', 'SL' , 1081);
insert into departures values ('1260',' 29-APR-2006', 'SL' , 1081);
insert into departures values ('1260',' 27-JUN-2006', 'SL' , 1081);
insert into departures values ('1260',' 23-JUL-2006', 'SL' , 1081);
insert into departures values ('1260',' 28-AUG-2006', 'SL' , 1081);
insert into departures values ('1260',' 29-AUG-2006', 'SL' , 1081);
insert into departures values ('1260',' 01-SEP-2006', 'SL' , 1081);
insert into departures values ('1260',' 28-SEP-2006', 'SL' , 1081);
insert into departures values ('1260',' 29-SEP-2006', 'SL' , 1081);
insert into departures values ('15',' 08-APR-2006', 'WRP' , 1026);
insert into departures values ('15',' 08-JUL-2006', 'WRP' , 1026);
insert into departures values ('15',' 08-AUG-2006', 'WRP' , 1026);
insert into departures values ('15',' 08-SEP-2006', 'WRP' , 1026);
insert into departures values ('40',' 08-APR-2006', 'SL' , 1081);
insert into departures values ('40',' 08-JUL-2006', 'SL' , 1081);
insert into departures values ('40',' 08-AUG-2006', 'SL' , 1081);
insert into departures values ('40',' 08-SEP-2006', 'SL' , 1081);
insert into departures values ('59',' 08-APR-2006', 'ELL' , 1194);
insert into departures values ('59',' 08-JUL-2006', 'ELL' , 1194);
insert into departures values ('59',' 08-AUG-2006', 'ELL' , 1194);
insert into departures values ('59',' 08-SEP-2006', 'ELL' , 1194);
insert into departures values ('60',' 08-APR-2006', 'ELL' , 1194);
insert into departures values ('60',' 08-JUL-2006', 'ELL' , 1194);
insert into departures values ('60',' 08-AUG-2006', 'ELL' , 1194);
insert into departures values ('60',' 08-SEP-2006', 'ELL' , 1194);
insert into departures values ('101',' 08-APR-2006', 'KCH' , 1253);
insert into departures values ('101',' 08-JUL-2006', 'KCH' , 1253);
insert into departures values ('101',' 08-AUG-2006', 'KCH' , 1253);
insert into departures values ('101',' 08-SEP-2006', 'KCH' , 1253);
insert into departures values ('102',' 08-APR-2006', 'KCH' , 1253);
insert into departures values ('102',' 08-JUL-2006', 'KCH' , 1253);
insert into departures values ('102',' 08-AUG-2006', 'KCH' , 1253);
insert into departures values ('102',' 08-SEP-2006', 'KCH' , 1253);
insert into departures values ('103',' 08-APR-2006', 'KCH' , 1253);
insert into departures values ('103',' 08-JUL-2006', 'KCH' , 1253);
insert into departures values ('103',' 08-AUG-2006', 'KCH' , 1253);
insert into departures values ('103',' 08-SEP-2006', 'KCH' , 1253);
insert into departures values ('104',' 08-APR-2006', 'KCH' , 1253);
insert into departures values ('104',' 08-JUL-2006', 'KCH' , 1253);
insert into departures values ('104',' 08-AUG-2006', 'KCH' , 1253);
insert into departures values ('104',' 08-SEP-2006', 'KCH' , 1253);
insert into departures values ('329',' 08-APR-2006', 'WRP' , 1026);
insert into departures values ('329',' 08-JUL-2006', 'WRP' , 1026);
insert into departures values ('329',' 08-AUG-2006', 'WRP' , 1026);
insert into departures values ('329',' 08-SEP-2006', 'WRP' , 1026);
insert into departures values ('400',' 08-APR-2006', 'SL' , 1081);
insert into departures values ('400',' 08-JUL-2006', 'SL' , 1081);
insert into departures values ('400',' 08-AUG-2006', 'SL' , 1081);
insert into departures values ('400',' 08-SEP-2006', 'SL' , 1081);
insert into departures values ('500',' 08-APR-2006', 'RS' , 1368);
insert into departures values ('500',' 08-JUL-2006', 'RS' , 1368);
insert into departures values ('500',' 08-AUG-2006', 'RS' , 1368);
insert into departures values ('500',' 08-SEP-2006', 'RS' , 1368);
insert into departures values ('501',' 08-APR-2006', 'RS' , 1368);
insert into departures values ('501',' 08-JUL-2006', 'RS' , 1368);
insert into departures values ('501',' 08-AUG-2006', 'RS' , 1368);
insert into departures values ('502',' 08-APR-2006', 'ELG' , 1489);
insert into departures values ('502',' 08-JUL-2006', 'ELG' , 1489);
insert into departures values ('502',' 08-AUG-2006', 'ELG' , 1489);
insert into departures values ('502',' 08-SEP-2006', 'ELG' , 1489);
insert into departures values ('503',' 08-APR-2006', 'ELG' , 1489);
insert into departures values ('503',' 08-JUL-2006', 'ELG' , 1489);
insert into departures values ('503',' 08-AUG-2006', 'ELG' , 1489);
insert into departures values ('503',' 08-SEP-2006', 'ELG' , 1489);
insert into departures values ('518',' 08-APR-2006', 'CG' , 1345);
insert into departures values ('518',' 08-JUL-2006', 'CG' , 1345);
insert into departures values ('518',' 08-AUG-2006', 'CG' , 1345);
insert into departures values ('518',' 08-SEP-2006', 'CG' , 1345);
insert into departures values ('521',' 08-APR-2006', 'CG' , 1085);
insert into departures values ('521',' 08-JUL-2006', 'CG' , 1085);
insert into departures values ('521',' 08-AUG-2006', 'CG' , 1085);
insert into departures values ('521',' 08-SEP-2006', 'CG' , 1085);
insert into departures values ('600',' 08-APR-2006', 'WRP' , 1347);
insert into departures values ('600',' 08-JUL-2006', 'WRP' , 1347);
insert into departures values ('600',' 08-AUG-2006', 'WRP' , 1347);
insert into departures values ('600',' 08-SEP-2006', 'WRP' , 1347);
insert into departures values ('604',' 08-APR-2006', 'CG' , 1345);
insert into departures values ('604',' 08-JUL-2006', 'CG' , 1345);
insert into departures values ('604',' 08-AUG-2006', 'CG' , 1345);
insert into departures values ('604',' 08-SEP-2006', 'CG' , 1345);
insert into departures values ('606',' 08-APR-2006', 'SL' , 1081);
insert into departures values ('606',' 08-JUL-2006', 'SL' , 1081);
insert into departures values ('606',' 08-AUG-2006', 'SL' , 1081);
insert into departures values ('606',' 08-SEP-2006', 'SL' , 1081);
insert into departures values ('691',' 08-APR-2006', 'WRP' , 1347);
insert into departures values ('691',' 08-JUL-2006', 'WRP' , 1347);
insert into departures values ('691',' 08-AUG-2006', 'WRP' , 1347);
insert into departures values ('691',' 08-SEP-2006', 'WRP' , 1347);
insert into departures values ('723',' 08-APR-2006', 'CG' , 1085);
insert into departures values ('723',' 08-JUL-2006', 'CG' , 1085);
insert into departures values ('723',' 08-AUG-2006', 'CG' , 1085);
insert into departures values ('723',' 08-SEP-2006', 'CG' , 1085);
--insert into departures values ('724',' 08-APR-2006', 'CG' , 1085);
--insert into departures values ('724',' 08-JUL-2006', 'CG' , 1085);
--insert into departures values ('724',' 08-AUG-2006', 'CG' , 1085);
--insert into departures values ('724',' 08-SEP-2006', 'CG' , 1085);
insert into departures values ('1260',' 08-APR-2006', 'SL' , 1081);
insert into departures values ('1260',' 08-JUL-2006', 'SL' , 1081);
insert into departures values ('1260',' 08-AUG-2006', 'SL' , 1081);
insert into departures values ('1260',' 08-SEP-2006', 'SL' , 1081);
insert into reservation values ('1' , '01-APR-2006' , 'Ole Olson' , '2186942221' , '15' , '01-APR-2006');
insert into reservation values ('2' , '01-APR-2006' , 'Pete Peterson' , '2186943000' , '101' , '15-JUL-2006');
insert into reservation values ('3' , '01-APR-2006' , 'Swen Swenson' , '2186948822' , '101' , '18-APR-2006');
insert into reservation values ('4' , '11-APR-2006' , 'Andy Anderson' , '6025233510' , '606' , '21-APR-2006');
insert into reservation values ('5' , '17-APR-2006' , 'Torgie Torgenson' , '2082223333' , '606' , '17-MAY-2006');
insert into reservation values ('6' , '17-APR-2006' , 'Andy Anderson' , '6025233510' , '102' , '18-APR-2006');
insert into passenger values('Ole Olson', 1, 410 , 1);
insert into passenger values('Lena Olson', 2, 98 , 1);
insert into passenger values('Pete Peterson', 3, 315 , 2);
insert into passenger values('Hazel Peterson', 4, 315 , 2);
insert into passenger values('David Peterson', 5, 315 , 2);
insert into passenger values('Swen Swenson', 6, 345 , 3);
insert into passenger values('Olga Swenson', 7, 315 , 3);
insert into passenger values('Pete Swenson', 8, 409 , 3);
insert into passenger values('Andy Anderson', 9, 436 , 4);
insert into passenger values('Gloria Anderson', 10, 436 , 4);
insert into passenger values('Torgie Torgenson', 11, 578.5 , 5);
insert into passenger values('Andy Anderson', 12, 560 , 6);
insert into passenger values('Gloria Anderson', 13, 312 , 6);
insert into ticket values (1, 15, '01-APR-2006','10D');
insert into ticket values (1, 329,'01-APR-2006','12D');
insert into ticket values (2, 15, '01-APR-2006', '10E');
insert into ticket values (2, 329, '10-APR-2006', '12E');
insert into ticket values (3, 101, '15-JUL-2006', '3D');
insert into ticket values (3, 104, '23-JUL-2006', '4D');
insert into ticket values (4, 101, '15-JUL-2006', '3C');
insert into ticket values (4, 104, '23-JUL-2006', '4C');
insert into ticket values (5, 101, '15-JUL-2006', '3B');
insert into ticket values (5, 104, '20-JUL-2006', '4B');
insert into ticket values (6, 101, '18-APR-2006', '10A');
insert into ticket values (6, 104, '23-JUL-2006', '8B');
insert into ticket values (7, 101, '18-APR-2006', '10B');
insert into ticket values (7, 104, '30-JUL-2006', '8C');
insert into ticket values (8, 101, '18-APR-2006', '10C');
insert into ticket values (8, 104, '23-JUL-2006', '8D');
insert into ticket values (9, 606, '27-APR-2006', '12B');
insert into ticket values (9, 691, '08-JUL-2006', '12A');
insert into ticket values (10, 606, '20-APR-2006', '12C');
insert into ticket values (11, 606, '17-MAY-2006', '12B');
insert into ticket values (11, 691, '19-MAY-2006', '13B');
insert into ticket values (12, 102, '18-APR-2006', '10B');
insert into ticket values (12, 103, '19-APR-2006', '7B');
insert into ticket values (13, 102, '18-APR-2006', '7C');
insert into ticket values (13, 103, '23-APR-2006', '3C');
COMMIT;
describe ticket
select * from TICKET;
describe passenger
select * from PASSENGER;
describe reservation
select * from RESERVATION;
describe departures
select * from DEPARTURES;
describe equip_type
select * from EQUIP_TYPE;
describe pilots
select * from pilots;
describe flight
select * from flight;
describe airport
select * from airport;
---------------------------------------------------------------------------------------------------------------------------------------------------------------
What are the sql commands for the following questions?
1.Display the origin, destination, departure time from origin, and arrival time at destination for all flights that occur in the same time zone. Your results should be displayed in order by flight number.
2.Display the code, location, and elevation of all airports without a hub airline. Your results should be in descending order by elevation.
3.Display the departures originating from Los Angeles, CA. Include in your results flights from Los Angeles for which no departures currently exist. Los Angeles, CA and not LAX should be used in the WHERE clause of your query.
4.Display the flight numbers and the codes for the origins and destinations of all flight reservations made by Andy Anderson.
5.Display the seating capacity, fuel capacity, and miles per gallon for all aircraft manufactured by Boeing. Information about each equipment type should be displayed only once.
Explanation / Answer
1. select origin,destination,departure_time,arrival_time from flights group by origin,destination order by flight_number;
This sql query retrieves the origin name,destination and their respective times departure and arrival. Group by clause will group the data and considers origin and destination and prints these Accordingly in the order of flight number.
2. Select airport_code,location,elevation from airport where hub_airline is null order by elevation desc;
3. Select flight _ number,departure_time,pilot_id from departure d,flight f,airport a where d.flight_number=f.flight_number and a.airport_code=f.origin and a.airport_location ='Los Angeles, CA';
4. Select flight_number,origin,destination from flight f,ticket t,passenger p where p.passenger_name='Andy Anderson' and p.itinerary_number=t.itinerary_number and t.flight_number= f.flight_number;
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.