{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Data Mgmt Lab_Part_18 - 52 Chapter 5 FROM WHERE AND 9...

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

View Full Document Right Arrow Icon
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 E.eid NOT IN ( SELECT DISTINCT C.eid FROM Certified C )
Background image of page 1

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

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}