Question: Using an OR statement and a WHERE join, display flight number, origination and departure for flights that originate from an airport that does not have

Using an "OR" statement and a "WHERE" join,
Using an "OR" statement and a "WHERE" 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. ) FL_RIGHT_NO BAL_ORIG FL._DEST AIR_CODE AIR_HUB_AIRLINE 1 2. 3 4 5 6 59 SFO 101 FLG 198 LAX 329 LAX 400 LAX 501 DEW 518 SFO 691 SFO 723 DTH 1260 SFO PEX PEX SFO PHX IAH PRX PHX 520 FLG LAX LAX LAX DFW SEO SEO DTH SFO (null) (null) (null) (null) (null) American (null) (null) American (null) 7 8 9 JFK PHX 10

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!