I need a SQL query to the following problem: The following relations keep track

Question

I need a SQL query to the following problem:

The following relations keep track of airline flight information:

Flights ( flightNo: int, fromDes: varchar2(50) , toDes: varchar2(50), distance: int, departs: Date, arrives: Date, price: real)

Aircraft ( airplaneID: int, airplaneName: varchar2(50), cruisingRange: int)

Certified ( employeeID: int, airplaneID: int)

Employees ( employeeID: int, employeeName: varchar2(50), salary: int)

X = One City Y = A different City

A customer wants to travel from X to Y with no more than two changes of flight. List the choice               of departure times from X if the customer wants to arrive in Y by 6 pm.

Explanation / Answer

select flightNo from flights where fromDes = X and toDes = Y;

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

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