| Title | Topics | Action | |||
|---|---|---|---|---|---|
| 74 | Add One StudentAdd a new student with a single `INSERT` that names its columns. Leave `id` out ... | easy | ○ Not Started | INSERT, UPDATE & DELETE | Solve |
| 75 | A Course With Default CreditsAdd a course called 'Web Development' with `code` 'CS240', in department 1 (Comp... | easy | ○ Not Started | INSERT, UPDATE & DELETE | Solve |
| 76 | Noah Declares a MajorNoah Kim (student `id` 4) has had no declared major until now. Update his row so... | easy | ○ Not Started | INSERT, UPDATE & DELETE | Solve |
| 77 | Ten Percent More for Third-Year CoursesThird-year courses cost more from next term. Raise `fee` by ten percent for ever... | easy | ○ Not Started | INSERT, UPDATE & DELETE | Solve |
| 78 | Olivia Gives Up Her OfficeOlivia Grant (instructor `id` 10) is moving to remote teaching and no longer has... | easy | ○ Not Started | INSERT, UPDATE & DELETE | Solve |
| 79 | Cancel the Empty Drawing CourseDrawing Fundamentals (ART140, course `id` 13) is cancelled: delete that one row ... | easy | ○ Not Started | INSERT, UPDATE & DELETE | Solve |
| 80 | Three Enrollments in One StatementAiden Rahman (28), Zoe Campbell (29) and Leo Martin (30) are the three students ... | medium | ○ Not Started | INSERT, UPDATE & DELETE | Solve |
| 81 | Graduate the Long-Standing StudentsEveryone who joined in 2022 or earlier and is still `active` has finished their ... | medium | ○ Not Started | INSERT, UPDATE & DELETE | Solve |
| 82 | Curve the Computer Science GPAsAdd 0.1 to the `gpa` of every Computer Science major (`major_department_id` 1), ... | medium | ○ Not Started | INSERT, UPDATE & DELETE | Solve |
| 83 | Purge the Unpaid Dropped EnrollmentsFour enrollments were `dropped` (ids 23, 26, 38 and 55). Delete only the dropped... | medium | ○ Not Started | INSERT, UPDATE & DELETE | Solve |
| 84 | Withdrawals and a Cancelled CourseTwo things happen at term end. First, the two students `on_leave`, Ethan Walsh (... | hard | ○ Not Started | INSERT, UPDATE & DELETE | Solve |
| 85 | A New Instructor Takes Over BUS320Business (department 5) hires Nadia Farouk to teach Financial Accounting. First ... | hard | ○ Not Started | INSERT, UPDATE & DELETE | Solve |