both a red and a green boat Lipyeow Lim -‐-‐ University of Hawaii at Manoa 3 SELECT S1.sname FROM Sailors S1, Reserves R1, Boats B1 WHERE S1.sid=R1.sid AND R1.bid=B1.bid AND ( B1.color=`red’ OR AND B1.color=`green’) SELECT S1.sname FROM Sailors S1, Reserves R1, Boats B1, Reserves R2, Boats B2 WHERE S1.sid=R1.sid AND R1.bid=B1.bid AND S1.sid=R2.sid AND R2.bid=B2.bid AND B1.color=`red’ AND B2.color=`green’