已知三个关系:S(,姓名,性别);C(课程编号,课程名称,学时)SC(,课程编号,分数)若要查询所有选了课的学生的和姓名,下列语句正确的是( )
A.
select 学号,姓名 from s WHERE 学号 in (select * from sc)
B.
select ,姓名 from s WHERE in (select * from sc where s.=sc. )
C.
select,姓名 from s WHERE exists (select * from sc where s.=sc. )
D.
(D)select,姓名 from s WHERE exists (select * from sc where s. =sc. )