Question: Flights: (flno: integer, origin: string, destination: string, distance, integer, departs: timestamp, arrives: timestamp, price: integer) Aircraft: (aid: integer, aname: string, cruisingrange: integer) Certified: (eid: integer,

Flights: (flno: integer, origin: string, destination: string, distance, integer, departs: timestamp, arrives: timestamp, price: integer) Aircraft: (aid: integer, aname: string, cruisingrange: integer) Certified: (eid: integer, aid: integer) Employees: (eid: integer, ename: string, salary: integer) Note that the employees relation describes pilots and other kinds of employees as well; every pilot is certified for some aircraft, and only pilots are certified to fly. Write the two following queries in SQL (Questions 10 and 11). Question 10 List in reverse alphabetical order all pilots who are certified to fly some Airbus plane
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
