查询选修了课程号为“MATHS”的学生的姓名和年龄,若用下列SQL的SELECT语句表达时,错误的是( )。
- AA) SELECT SNAME,AGE FROM S WHERE S. S# =(SELECT SC. S# FROM SC WHERE
- Bc.c# ='MATHS ')
- CB ) SELECT SNAME, AGE FROM S WHERE S. S# =(SELECT S S# FROM SC WHERE
- DSC. C# =' MATHS ')
- EC) SELECT SNAME, AGE FROM S, SC WHERE S. S# =SC. S# AND SC. C# ='MATHS'
- FORDER BY S. S#
- GD)SELECT SNAME, AGE FROM S, SC WHERE S. S# =SC. S# AND SC. C# ='MATHS'