A.SELECT DISTINCTSnameB.SELECT DISTm CTSname FROMS FROMS WHERE EXISTS WHERE 0< (SELECT* (SELECTCOUNT(*) FROM SPJ FROM SPJ WHERE S.Sno=SPJ.SnO WHERE S.Sno;SPJ.Sno AND SPJ.Pno;,P3, AND SPJ.Pno=’P3’)C.SELECT ShameD.SELECT Sname FROMS FROMS,SPJ WHERE EXISTS WHERES.Sno=SPJ.Sno (SELECT* ANDSPJ.Pno=’P3’) FROM SPJ GROUP BYSname WHERE S. Sno=SPJ. Sno AND SPJ. Pno=’P3’)
A.SELECT DISTINCTSname
B.SELECT DISTm CTSname
FROMS FROMS
WHERE EXISTS WHERE 0<
(SELECT* (SELECTCOUNT(*)
FROM SPJ FROM SPJ
WHERE S.Sno=SPJ.SnO WHERE S.Sno;SPJ.Sno
AND SPJ.Pno;,P3, AND SPJ.Pno=’P3’)
C.SELECT Shame
D.SELECT Sname
FROMS FROMS,SPJ
WHERE EXISTS WHERES.Sno=SPJ.Sno
(SELECT* ANDSPJ.Pno=’P3’)
FROM SPJ GROUP BYSname
WHERE S. Sno=SPJ. Sno
AND SPJ. Pno=’P3’)