Consider the following relation

Answer the following queries in SQL

A. find SNAME of the suppliers who supplies at least all the parts which is provided by supplier S2.

B. find SNAME of the suppliers whom provides one red part at least.

C. find SNAME of the suppliers who does not provide part P2.

D. find SNAME of the suppliers who provides all the parts.

E. find P# of the parts which can be provided from at least three suppliers.

S (S#, SNAME, STATUS, CITY) P(P#, PNAME, COLOR, WEIGHT, CITY) SP (S#, P#, QTY)