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