180605_Conditional SELECT with C

There is a table courses with columns: student and class

Please list out all classes which have more than or equal to 5 students.

For example, the table:

Should output:

Note:
The students should not be counted duplicate in each course.

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