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