| Title | Topics | Action | |||
|---|---|---|---|---|---|
| 4 | Counting Every StudentHow many students does the college have? Return a single row with one column, `t... | easy | ○ Not Started | Aggregates & GROUP BY | Solve |
| 5 | Students With a Posted GPAThree students have no `gpa` yet (it is NULL until their first grades are posted... | easy | ○ Not Started | Aggregates & GROUP BY | Solve |
| 6 | Budget Totals Across DepartmentsSummarise the yearly budgets in `departments` in a single row: `total_budget` (t... | easy | ○ Not Started | Aggregates & GROUP BY | Solve |
| 7 | Average Grade, RoundedWhat is the average grade across all enrollments that have one? Return one row w... | easy | ○ Not Started | Aggregates & GROUP BY | Solve |
| 8 | Students Per CityCount how many students come from each home city. Return `city` and `students` (... | easy | ○ Not Started | Aggregates & GROUP BY | Solve |
| 9 | Distinct Students EnrolledThe `enrollments` table has 90 rows, but many students appear in it several time... | easy | ○ Not Started | Aggregates & GROUP BY | Solve |
| 10 | Students Per DepartmentFor each department, count the students who have declared it as their major. Ret... | medium | ○ Not Started | Aggregates & GROUP BY | Solve |
| 11 | Busiest Courses FirstCount the enrollments in each course. Return `code` and `enrollments` (the count... | medium | ○ Not Started | Aggregates & GROUP BY | Solve |
| 12 | Cities With More Than Three StudentsWhich home cities have more than three students? Return `city` and `students` (t... | medium | ○ Not Started | Aggregates & GROUP BY | Solve |
| 13 | Courses Averaging Above 80Find the courses whose average posted grade is above 80. Return `code`, `graded`... | medium | ○ Not Started | Aggregates & GROUP BY | Solve |
| 14 | Courses Per Semester and LevelBreak the course catalogue down by term and year level. Return `semester`, `leve... | medium | ○ Not Started | Aggregates & GROUP BY | Solve |
| 15 | Students Per Major, Undeclared IncludedCount the students in each major, and keep the four undeclared students as their... | hard | ○ Not Started | Aggregates & GROUP BY | Solve |
| 16 | Departments With Ten or More Completed GradesFor each department, look only at enrollments with `status = 'completed'` in tha... | hard | ○ Not Started | Aggregates & GROUP BY | Solve |
| 17 | Department Pay Versus the College AverageCompare each department's instructors with the college as a whole. Return `depar... | hard | ○ Not Started | Aggregates & GROUP BY | Solve |