单项选择题

查询选修了课程号为“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

D.SELECT SNAME,AGE FROM S WHERE
S.S#<