设数据库mydb中有3个表：
Student(Sno,Sname,Sage)
Course(Cno,Cname)
SC(Sno,Cno,Grade)
其中，Sno,Sname,Sage表示学生的学号、姓名、年龄，Cno、Cname表示课程的课程编号、课程名称，Grade表示成绩
查询"高等数学"课程低于60分的学生的学号与姓名，正确的SQL语句是
A.
select Sname,Sno from Student where '高等数学'.Grade < 60
B.
select Sname,Sno from Student,Course,SC where Cname = '高等数学' and Grade < 60
C.
select Sno,Sname from Student,Course,SC where Cname = '高等数学' and Grade < 60 and Student.Sno = SC.Sno and Course.Cno = SC.Cno
D.
select Sno,Sname from Student where Sno in (select Sno from SC where Grade < 60 and Cno in (select Cno from Course where Cname = '高等数学'))
