在“学生-选课-课程”数据库中如下三个关系: S(S#,SNAME,SEX,AGE),SC(S#,C#,GRADE),C(C#,CNAME,TEACHER)查询选修了课程号为“C1”的学生的姓名和年龄,若用下列SQL的SELECT语句表达时,哪一个是错误的
A. SELECT SNAME,AGE FROM S WHERE
S.S# =(SELECT S
C.S# FROM SC WHERE
C.C#='C1')
B. SELECT SNAME,AGE FROM S,SC WHERE
S.S#=S
C.S# AND S
C.C#='C1'
C.SELECT SNAME,AGE FROM S,SC WHERE
S.S#=S
C.S# AND S
C.C#='C1'ORDER BY
S.S#
D.SELECT SNAME,AGE FROM S WHERE
S.S# =(SELECT S
C.S# FROM SC WHERE S
C.C#='C1')