-- Find the supplier of red parts.
select S.S_NO, S.SNAME, P.PNAME, P.COLOR 
from S, P, SP
where S.S_NO = SP.S_NO
and   SP.P_NO = P.P_NO
and   P.COLOR = "Red";
\q

Find the suppliers of red parts.