THANKS SO MUCH CHEGG!!! The following relations keep track of airline flight inf

Question

THANKS SO MUCH CHEGG!!!

The following relations keep track of airline flight information Flights (flno: integer, from: string, to: string, distance: integer, departs: time, arrives: time, price: real) 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 each of the following queries in SQL. Complete the missing information

Explanation / Answer

Select employees.ename from employees, certified, aircraft

where employees. eid =certified.eid and certified.aid =aricraft.aid

group by employees.ename

having aircraft.aname like '%Boeing%' and aircraft.cruisingrange > 1000;

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.