查询考试成绩大于75分的学生的学号和姓名,正确的语句是()。
A. SELECT Sno, Sname FROM sC WHERE Grade>75
B. SELECT Sno, Sname FROM Student WHERE Grade>75
C. SELECT Sno, Sname FROM Student WHERE Sno lN(SELECT Sno FROM SC WHERE Grade>75 )
D. SELECT Sno, Sname FROM Student WHERE Sno lN(SELECT Sno FROM SC HAVING Grade>75 )