单项选择题

查询选修了课程号为“MATHS”的学生的姓名和年龄,若用下列SQL的SELECT语句表达时,错误的是( )。

A.SEIECT SNAME, ADE FROM S WHERE S#=(SELECT S S# FROM SC WHERE C#='MATHS')
B.SELECT SNAME, AGE FROM S WHERE S#=(SELECT S S# FROM SC WHERE S C#='MATHS')
C.SELECT SNAME, AGE FROM S, SC WHERE S#=SS# AND S C#='MATHS' ORDER BY S#
D.SELECT SNAME, AGE FROMS, SC WHERE S#=SS# AND SC#='MATHS'