查询选修了课程号为“C1”的学生的姓名和年龄，若用下列SQL的SELECT语句表达时，哪一个是错误的

A:SELECT SNAME，AGE FROM S WHERE B:S．S#
=(SELECT S C:S# FROM SC WHERE D:C#='C1') E:SELECT SNAME，AGE FROM S，SC
WHERE F:S．S#=S G:S# AND S H:C#='C1' I:SELECT SNAME，AGE FROM S，SC
J:SELECT SNAME，AGE FROM S WHERE K:S．S#<

查询选修了课程号为'C2'的学生号和姓名，若用下列SQL的SELECT语句表达时，哪一个是错误的

A:SELECT B:S．S#，SNAME FROM S WHERE C:S．S#=(SELECT S D:S# FROM SC WHERE C#=‘C2’) E:SELECT F:S．S#，SNAME FROM S，SCWHERE G:S．S#=S H:S#AND C#=‘C2’ I:SELECT J:S．S#，SNAME FROM S， K:SELECT L:S．S#，SNAME FROM S

查询选修了课程号为“C2”的学生号和姓名，若用下列SQL的SELECT语句表达时，哪一个是错误的

A:SELECT S.S#，SNAME FROM S WHERE S.S#
(SELECT SC. S# FROM SC WHERE C#='C2') B:SELECT S.S#，SNAME FROMS，SC
WHERE S.S#=SC.S# AND C#='C2' C:SELECT S.S#，SNAME FROM S,SC
&nb D:SELECTS.S#，SNAME FROM S WHERE S.S#
IN(SELECT SC. S# FROM SC WHERE C#='C2')

查询选修了课程号为C2的学生号和姓名，用下列SQL的SELECT语句表达时，哪一个是错误的( )

A:SELECT S.S#，SNAME FROM S WHERE S.S#
=(SELECT SC) S# FROM SC WHERE C#=‘C2’) B:SELECT S.S#，SNAME FROMS，SC
WHERE S.S# S C:S# AND C#=‘C2’C) SELECT S. S#，SNAME FROM S，SC
WHERE S.S# SC) S# AND C#=‘C2’ORDER BY S.S# D:SELECT S.S#，SNAME FROM S

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

查询选修了课程号为'C2'的学生号和姓名，若用下列SQL的SELECT语句表达时，哪一个是错误的

A:SELECT S#，SNAME FROM S WHERE S#=(SELECT SS# FROM SC WHERE C#=‘C2’) B:SELECT S#，SNAME FROM S，SCWHERE S#=SS#AND C#=‘C2’ C:SELECT S#，SNAME FROM S，SCWHERE S#=SS#AND C#=‘C2’ORDER BY S# D:SELECT S#，SNAME FROM S WHERE S#IN (SELECT SS# FROM SC WHERE C#=‘C2’)

查询选修了课程号为“C2”的学生号和姓名，若用下列SQL的SELECT语句表达时，哪一个是错误的

A:SELECT S#，SNAME FROM S WHERE S# (SELECT S S# FROM SC WHERE C#='C2') B:SELECT S#，SNAME FROMS，SC WHERE S#=SS# AND C#='C2' C:SELECT S#，SNAME FROM S,SC WHERE S=SS# AND C#='C2'ORDER BY S#． D:SELECTS#，SNAME FROM S WHERE S# IN(SELECT S S# FROM SC WHERE C#='C2')

查询选修了课程号为'C2'的学生号和姓名，若用下列SQL的SELECT语句表达时，哪一个是错误的？（）

A:SELECT S#，SNAME FROM S WHERE S# = (SELECT SS# FROM SC WHERE C# = 'C2' ) B:SELECT S#，SNAME FROM S，SCWHERE S# = SS# AND C# = 'C2' C:SELECT S#，SNAME FROM S，SC WHERE S# = SS# AND C# = 'C2' ORDER BY S# D:SELECT S#，SNAME FROM S WHERE S# IN (SELECT SS# FROM SC WHERE C# ='C2' )