超过 5 名学生的课

HAVING

SELECT
  class
FROM
  courses
GROUP BY class
HAVING COUNT(DISTINCT student) >= 5