数据库查询-请列出所有超过或等于5名学生的课

解题思路：

1.按相同的类型分组：

select class from courses group by class

2.满足“超过或等于5名学生的课”的条件：

select class from courses group by class having count(class) >= 5

3.满足‘学生在每个课中不应被重复计算’：

select class from (select distinct * from courses) as c group by c.class having count(class)>=5

若select distinct class from courses group by class having count(class) >= 5，只是把class重复的去掉了，学生的不重复计算条件不满足