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