文巾解题 596. 超过5名学生的课

1 题目描述

2 解题思路

先求出不同的课，每门课有几个不同的学生选了

SELECT A.class 
FROM (SELECT class,COUNT(DISTINCT student) AS num
      FROM courses
      GROUP BY class
) AS A
WHERE A.num>=5