Classes with Max Students
ASKED IN INTERVIEWCanvas
Problem Statement
Educational institutions use Canvas to manage course loads. You need to identify which class had the highest enrollment during the Fall semester.
Rules:
- Only consider courses where the semester is recorded as Fall.
- If multiple classes have the same maximum enrollment, any one of them is acceptable.
- Output column: class_name.
Tests your understanding of
Grouping, Aggregation and Filtering
Input Tables
Courses
| class_id(INTEGER) | class_name(VARCHAR) | semester(VARCHAR) |
|---|---|---|
| 1 | Algorithms | Fall |
| 2 | Data Structures | Spring |
| 3 | Machine Learning | Fall |
| 4 | SQL Systems | Fall |
Enrollments
| enrollment_id(INTEGER) | class_id(INTEGER) | student_id(INTEGER) |
|---|---|---|
| 101 | 1 | 50 |
| 102 | 1 | 51 |
| 103 | 3 | 52 |
| 104 | 4 | 53 |
| 105 | 4 | 54 |
| 106 | 4 | 55 |
Professors
| professor_id(INTEGER) | class_id(INTEGER) | name(VARCHAR) |
|---|---|---|
| 201 | 1 | Dr. Smith |
| 202 | 4 | Dr. Jones |
Expected Output
| class_name(VARCHAR) |
|---|
| SQL Systems |
Tags
EasyASKED IN INTERVIEWGroupingAggregationFiltering
10-15 min
79%