select classfrom(select distinct student, classfrom courses ) tgroup by class having count(class)>=5

脚本如下：

select classfrom(select distinct student, classfrom courses ) tgroup by class having count(class)>=5

注意 可能有重复记录