---

对Student(Sno,Sname)和SC(Sno,Cno,Grade)表，查询考试成绩小于60分的学生的学号和姓名，正确的语句是（ ）。
A. SELECT Sno, Sname FROM SC WHERE Grade<60
B. SELECT Sno, Sname FROM Student WHERE Grade<60
C. SELECT Sno, Sname FROM Student WHERE Sno IN( SELECT Sno FROM SC WHERE Grade<60 )
D. SELECT Sno, Sname FROM StudentWHERE Sno FROM SC AND Grade<60

---

出自：国家开放大学数据库应用技术模拟试题

显示答案