检索“至少选修课程号为"C1"，的学生姓名(SNAME)”的SQL语句是（ ）。

A．SELECT S.sname FROM S，SC WHERE C．cno="C1"

B．SELECT S.sname FROM S，SC WHERE C．cno="C1"AND S.sno=SC．sno

C．SELECT S.sname FROM S，SC FOR C．cno="C1"

D．SELECT S.sname FROM S，sc FOR C．cno="C1" AND S.sno=SC．sno