Data Mgmt Lab_Part_18 - 52 Chapter 5 FROM Aircraft A1 WHERE...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 52 Chapter 5 FROM Aircraft A1 WHERE A1.aid = C.aid AND A1.aname LIKE ‘Boeing%’ )) 9. SELECT F.departs FROM Flights F WHERE F.flno IN ( ( SELECT F0.flno FROM Flights F0 WHERE F0.from = ‘Madison’ AND F0.to = ‘New York’ AND F0.arrives < ‘18:00’ ) UNION ( SELECT F0.flno FROM Flights F0, Flights F1 WHERE F0.from = ‘Madison’ AND F0.to <> ‘New York’ AND F0.to = F1.from AND F1.to = ‘New York’ AND F1.departs > F0.arrives AND F1.arrives < ‘18:00’ ) UNION ( SELECT F0.flno FROM Flights F0, Flights F1, Flights F2 WHERE F0.from = ‘Madison’ AND F0.to = F1.from AND F1.to = F2.from AND F2.to = ‘New York’ AND F0.to <> ‘New York’ AND F1.to <> ‘New York’ AND F1.departs > F0.arrives AND F2.departs > F1.arrives AND F2.arrives < ‘18:00’ )) 10. SELECT Temp1.avg - Temp2.avg FROM ( SELECT AVG (E.salary) AS avg FROM Employees E WHERE E.eid IN ( SELECT DISTINCT C.eid FROM Certified C )) AS Temp1, ( SELECT AVG (E1.salary) AS avg FROM Employees E1 ) AS Temp2 11. SELECT E.ename, E.salary FROM Employees E WHERE...
View Full Document

This note was uploaded on 01/17/2012 for the course EGN 4302 taught by Professor Dr.vishak during the Fall '12 term at University of Central Florida.

Page1 / 3

Data Mgmt Lab_Part_18 - 52 Chapter 5 FROM Aircraft A1 WHERE...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online