A.SELECT DISTINCT Sno, Sname FROM Student, SC WHERE Student.Sno = SC.Sno;
B.SELECT Sno, Sname FROM Student, SC WHERE Student.Sno = SC.Sno;
C.SELECT DISTINCT Sno, DISTINCT Sname FROM Student WHERE Student.Sno IN (SELECT Sno FROM SC);
D.SELECT Sno, Sname FROM Student WHERE Student.Sno IN (SELECT DISTINCT Sno FROM SC);