| Title | Topics | Action | |||
|---|---|---|---|---|---|
| 1 | Students and Their MajorsList every student with the name of their major department. Return three columns... | easy | ○ Not Started | Joins | Solve |
| 96 | Instructors and Their DepartmentsList every instructor with the name of the department they belong to. Return `fi... | easy | ○ Not Started | Joins | Solve |
| 97 | Who Heads Each DepartmentFor each department, show the instructor who heads it. Return `department` (the ... | easy | ○ Not Started | Joins | Solve |
| 98 | Who Teaches in Winter 2026List every instructor teaching a course this winter. Return the instructor's `fi... | easy | ○ Not Started | Joins | Solve |
| 99 | Courses Sorted by Department NameList all 14 courses with the department that offers them. Return `code`, `title`... | easy | ○ Not Started | Joins | Solve |
| 100 | Top Marks With Student NamesShow every grade of 90 or more together with the student who earned it. Return `... | easy | ○ Not Started | Joins | Solve |
| 2 | Courses Nobody Is TakingFind every course that has no enrollments at all. Return `code` and `title`, sor... | medium | ○ Not Started | Joins | Solve |
| 101 | Every Instructor's Course LoadFor every instructor, count the courses they teach. Return `first_name`, `last_n... | medium | ○ Not Started | Joins | Solve |
| 102 | Students Who Never EnrolledThree students joined in 2026 and have not enrolled in anything yet. Find them w... | medium | ○ Not Started | Joins | Solve |
| 103 | Who Earned an A in WhatList every A grade on record with the student's name and the course code. Return... | medium | ○ Not Started | Joins | Solve |
| 104 | Classmates From Ava's CityFind every other student who lives in the same city as Ava Patel, without typing... | medium | ○ Not Started | Joins | Solve |
| 3 | How Many Students Each Instructor TeachesFor every instructor, count how many different students are enrolled in any of t... | hard | ○ Not Started | Joins | Solve |
| 105 | Courses in Progress per StudentFor every student, count how many courses they are taking right now: enrollments... | hard | ○ Not Started | Joins | Solve |
| 106 | Which Cities Each Department ReachesFor each department, count the distinct students who have ever enrolled in one o... | hard | ○ Not Started | Joins | Solve |