A.
select * from stu where cid ='计算机一班';
B.
select * from stu where cid in(select cid from class);
C.
select * from stu where cid in(select cid from class where cname='计算机一班');
D.
select * from stu where cid not in(select cid from class where cname='计算机一班');