Using an OR statement and a Cartesian product / WHERE join, display flight number, origination and...

 

Transcribed Image Text:

Using an "OR" statement and a "Cartesian product / WHERE" join, display flight number, origination and destination for flights that originate from an airport that does not have a hub airline or flights that originate from an airport that is a hub for American Airlines. Order by origination airport. 1 2 3 4 5 6 7 8 9 10 11 FL_FLIGHT_NO FL_ORIG FL_DEST AIR HUB_AIRLINE American American. (null) (null) 1 2 3 4 2. Using an SET OPERATOR statement and a "JOIN ON" join, display flight number, origination and departure for flights that originate from an airport that does not have a hub airline or flights that originate from an airport that is a hub for American Airlines. Order by origination airport. 5 6 7 8 9 10 11 1 2 3 4 5 500 IAH 521 IAH 198 LAX 600 PHX 604 PHX 298 PHX 60 PHX 40 PHX 15 PHX 104 PHX 606 PHX 6 7 8 9 FL FLIGHT_NO FL_ORIG FL_DEST AIR HUB_AIRLINE American. American (null) (null) (null) 10 11 12 13 14 DEW DTW SFO SFO SFO LAX 500 IAH 521 IAH 198 LAX 600 PHX 604 PHX 298 PHX 60 PHX 40 PHX 15 PHX 104 PHX 606 PHX SEO LAX LAX FLG SEO (null) (null) (null) (null) (null) DEW DTW SEO SEO SFO LAX SEO LAX LAX FLG SFO 3. Display the flight number, departure date and equipment type for all equipment that is manufactured by Concorde. Order by departure date and flight number. DEP_FLIGHT_NO DEP_DEP_DATE EQ_EQUIP_TYPE 1 SSM 2 VIT 3 WBK (null) (null) 502 08-APR-17 503 08-APR-17 503 28-APR-17 503 29-APR-17 502 08-JUL-17 503 08-JUL-17 503 23-JUL-17 503 27-JUL-17 503 29-JUL-17 503 30-JUL-17 502 08-AUG-17 503 08-AUG-17 502 08-SEP-17 503 08-SEP-17 (null) (null) (null) (null) (null) (null) CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE 4. Using a SET OPERATOR, display the IDs and names of pilots who are not currently scheduled for a departure. PIL PILOT_ID PIL_PILOTNAME Moore, Sharon S. Tabor, Victor T. Knighton, Bill Using an "OR" statement and a "Cartesian product / WHERE" join, display flight number, origination and destination for flights that originate from an airport that does not have a hub airline or flights that originate from an airport that is a hub for American Airlines. Order by origination airport. 1 2 3 4 5 6 7 8 9 10 11 FL_FLIGHT_NO FL_ORIG FL_DEST AIR HUB_AIRLINE American American. (null) (null) 1 2 3 4 2. Using an SET OPERATOR statement and a "JOIN ON" join, display flight number, origination and departure for flights that originate from an airport that does not have a hub airline or flights that originate from an airport that is a hub for American Airlines. Order by origination airport. 5 6 7 8 9 10 11 1 2 3 4 5 500 IAH 521 IAH 198 LAX 600 PHX 604 PHX 298 PHX 60 PHX 40 PHX 15 PHX 104 PHX 606 PHX 6 7 8 9 FL FLIGHT_NO FL_ORIG FL_DEST AIR HUB_AIRLINE American. American (null) (null) (null) 10 11 12 13 14 DEW DTW SFO SFO SFO LAX 500 IAH 521 IAH 198 LAX 600 PHX 604 PHX 298 PHX 60 PHX 40 PHX 15 PHX 104 PHX 606 PHX SEO LAX LAX FLG SEO (null) (null) (null) (null) (null) DEW DTW SEO SEO SFO LAX SEO LAX LAX FLG SFO 3. Display the flight number, departure date and equipment type for all equipment that is manufactured by Concorde. Order by departure date and flight number. DEP_FLIGHT_NO DEP_DEP_DATE EQ_EQUIP_TYPE 1 SSM 2 VIT 3 WBK (null) (null) 502 08-APR-17 503 08-APR-17 503 28-APR-17 503 29-APR-17 502 08-JUL-17 503 08-JUL-17 503 23-JUL-17 503 27-JUL-17 503 29-JUL-17 503 30-JUL-17 502 08-AUG-17 503 08-AUG-17 502 08-SEP-17 503 08-SEP-17 (null) (null) (null) (null) (null) (null) CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE CONCORDE 4. Using a SET OPERATOR, display the IDs and names of pilots who are not currently scheduled for a departure. PIL PILOT_ID PIL_PILOTNAME Moore, Sharon S. Tabor, Victor T. Knighton, Bill