CODE EXAMPLE FOR SQL

find class >=5 from list

SELECT class
FROM
    (SELECT class, COUNT(DISTINCT student) AS student_num
FROM Courses
GROUP BY class) AS table_1
WHERE student_num >=5;