select s.sname 
from sailors S, reserves R, Boats B 
where s.sid = r.sid and r.bid = b.bid and b.color = 'red';

