查询选修了课程号为“C1”的学生的姓名和年龄,若用下列SQL的SELECT语句表达时,哪一个是错误的
A.SELECT SNAME,AGE FROM S WHERE S# =(SELECT SS# FROM SC WHERE C#='C1')
B.SELECT SNAME,AGE FROM S,SC WHERE S#=SS# AND SC#='C1'
C.SELECT SNAME,AGE FROM S,SC WHERE S#=SS# AND SC#='C1'ORDER BY S#
D.SELECT SNAME,AGE FROM S WHERE S# =(SELECT SS# FROM SC WHERE SC#='C1')