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,

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

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 Databases Questions!