A.SELECT DISTINCT Sname FROMS WHERE EXISTS (SELECT* FROM SPJ WHERE S. Sno=SPJ. SnO AND SPJ.Pno=’P3’)B.SELECT DISTmCT Sname FROMS WHERE 0< (SEIECT COUNT (*) FROM SPJ WHERES.Sno=SPJ.Sno AND SPJ.Pno=’P3’)C.SELECT Sname FROMS WHERE EXISTS (SELECT* FROM SPJ WHERES.Sno=SPJ.Sno ANDSPJ.Pno=’P3’)D.SELECT Sname FROMS,SPJ WHERES.Sno=SPJ.Sno ANDSPJ.Pno=’P3’) GROUP BYSname
A.SELECT DISTINCT Sname
FROMS
WHERE EXISTS
(SELECT*
FROM SPJ
WHERE S. Sno=SPJ. SnO
AND SPJ.Pno=’P3’)
B.SELECT DISTmCT Sname
FROMS
WHERE 0<
(SEIECT COUNT (*)
FROM SPJ
WHERES.Sno=SPJ.Sno
AND SPJ.Pno=’P3’)
C.SELECT Sname
FROMS
WHERE EXISTS
(SELECT*
FROM SPJ
WHERES.Sno=SPJ.Sno
ANDSPJ.Pno=’P3’)
D.SELECT Sname
FROMS,SPJ
WHERES.Sno=SPJ.Sno
ANDSPJ.Pno=’P3’)
GROUP BYSname