查询选了’数据库原理‘和’java‘的同学姓名select snamefrom student s, sc ,course cwhere s.sno=sc.sno and c.cno=sc.cno and cname='数据库原理' and sno___________________________
选项：

A: in (select sno from sc join course c on c.cno=sc.cno where cname='JAVA')
B: =(select sno from sc join course c on c.cno=sc.cno where cname='JAVA')
C: in (select sno from sc where cname='JAVA')