Question: e) Find distinct eids from the the possible eid, aid pairs of pilots and aircraft where the aircraft are those owned by the airline with
e) Find distinct eids from the the possible eid, aid pairs of pilots and aircraft where the aircraft are those owned by the airline with the exception of those on the specialized list, and the pairs are not among the eid, aid pairs in Certified. (This query should produce 10 rows of eids) f) Find pilots by eid who are certified to fly all aircraft the airline owns with the exception of those on the "specialized" list. (This query should produce 2 rows of eids)
Step by Step Solution
There are 3 Steps involved in it
To solve these SQLbased questions well need to write queries that match the criteria given in the qu... View full answer
Get step-by-step solutions from verified subject matter experts
