查找每个课程的去重后的学生数量大于5
select a.class "class" from(
select count(distinct(student)) num,class
from courses
group by class
)a where a.num>=5
查找每个课程的去重后的学生数量大于5
select a.class "class" from(
select count(distinct(student)) num,class
from courses
group by class
)a where a.num>=5