Report Classes with at Least Five Enrolled Students

### Problem Return each class with at least five students enrolled. The (student,class) key prevents duplicate enrollment rows for the same student in one class. Class ordering is unrestricted. ### Tables Table: `Courses` ```text +-------------+---------+ | Column Name | Type | +-------------+---------+ | student | varchar | | class | varchar | +-------------+---------+ (student, class) is the primary key (combination of columns with unique values) for this table. Each row of this table indicates the name of a student and the class in which they are enrolled. ``` ### Example ```text Courses (student,class): (Ada,Art), (Bo,Art), (Cam,Art), (Dee,Art), (Eli,Art), (Fox,Music) Output (class): (Art) ``` ### What a Strong Answer Covers - Count students separately for each class. - Include a class with exactly five enrolled students and return each qualifying class once. ### Follow-up Questions - How would you change the result if duplicate enrollment records were allowed? - How would you include classes with no students in a full enrollment report?