代码语言:javascript复制
select class
from courses
group by 1
having count(distinct student)>=5
select class
from courses
group by 1
having count(distinct student)>=5