在student、course和sc表的基础上,查询年龄小于20岁的学生的姓名、年龄和考试成绩,使用( )语句。
A.
select sname,sage,grade from student s join sc on s.sno=sc.sno
B.
select sname,sage,grade from student where sage<20
C.
select sname,sage,grade from student s join sc on s.sno=sc.sno where sage<20
D.
select sname,sage,grade from student s join sc on student.sno=sc.sno where sage<20