p.193a

"Find the names of sailors who have reserved a red boat"

SELECT S.sname

FROM Sailors S

WHERE S.sid IN (SELECT R.sid

FROM Reserves R

WHERE R.bid IN

(SELECT B.bid

FROM Boats B

WHERE B.color = 'red')

Previous slide

Next slide

Back to first slide

View graphic version