从student(sno,sname...)表和sc(sno,cno...)表,查询选修001号课程的学生姓名,下列语句表达正确的是( )。
A.
select sname from student,sc where student.sno=sc.sno and cno='001'
B.
select sname from student where sno = (select sno from sc where cno='001')
C.
select sname from student where sno in (select sno from sc where cno='001')
D.
select sname from student where exists (select * from student where cno='001' )