| Title | Topics | Action | |||
|---|---|---|---|---|---|
| 42 | Honour Roll Through a CTEWrite a CTE named `honour_roll` that selects `first_name`, `last_name` and `gpa`... | easy | ○ Not Started | CTEs | Solve |
| 43 | Cities With at Least Three StudentsCount the students in each `city` inside a CTE named `per_city` (columns `city` ... | easy | ○ Not Started | CTEs | Solve |
| 44 | Months One to TwelveUse a recursive CTE named `months` with a single column `n` to generate the numb... | easy | ○ Not Started | CTEs | Solve |
| 45 | Courses Beating the College AverageIn a CTE named `course_avg`, compute each course's average grade (`course_id` an... | medium | ○ Not Started | CTEs | Solve |
| 46 | How Full Each Course IsChain two CTEs. `per_course` counts the enrollments per `course_id` whose `statu... | medium | ○ Not Started | CTEs | Solve |
| 47 | Took Both CS101 and MATH110Define one CTE named `taken` that lists every completed enrollment as `student_i... | medium | ○ Not Started | CTEs | Solve |
| 48 | Winter Sign-Ups Week by WeekUse a recursive CTE named `weeks` to generate every Monday from `2025-12-01` to ... | hard | ○ Not Started | CTEs | Solve |
| 49 | Students, Staff and Pay per DepartmentBuild a one-row-per-department report from two CTEs: `majors` counts students pe... | hard | ○ Not Started | CTEs | Solve |