select class from (select count(distinct student) as num,class from courses group by class) a where num>=5 不说了,依旧很简单