Thank you so much people of Chegg!! This question has been haunting me for a whi

Question

Thank you so much people of Chegg!! This question has been haunting me for a while now! Thanks Alot!!

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 4. For each pilot who is certified for more than five aircrafts, find the eid and the minimum cruisingrange of the aircraft for which she or he is certified. SELECT FROM WHERE GROUP BY HAVING

Explanation / Answer

SELECT eid,max(cruisingrange)

FROM Certified c,Aircraft a

WHERE a.aid=c.aid

GROUP BY c.eid

HAVING count(c.eid>5);

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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