from 课程表 group by 课程号,课程名称 having count(选修人)>=3 麻烦把表结构说一下··这让人好理解些。
select count(*),sc.cnofrom Score sc group by sc.cno
