对Student(Sno,Sname)和SC(Sno,Cno,Grade)表，查询考试成绩大于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 IN( SELECT Sno FROM SC WHERE Grade>75 )
D. SELECT Sno, Sname FROM StudentWHERE Sno FROM SC AND Grade>75