This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.1. d) Find the sids of suppliers who supply some red part and some green part.
FROM Parts P, Catalog C
WHERE P.color='red' and P.pid=C.pid
AND EXISTS (
FROM Parts P2, Catalog C2
WHERE P2.color = 'green' AND C2.sid =C.sid AND P2.pid = C2.pid)...