a
create table s (学生 varchar2(20));
create table c (课程 varchar2(20));
create table sc (学生 varchar2(20), 课程 varchar2(20));
b
select * from s
where (select count(*) from sc where sc.学生 = s.学生) = (select count(*) from c)
b
select * from s
where (select count(*) from sc where sc.学生 = s.学生) >= 5