查询考试成绩大学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 Student
WHERE Sno FROM SC AND Grade>75
出自:国家开放大学数据库应用技术模拟试题