| Title | Topics | Action | |||
|---|---|---|---|---|---|
| 18 | Add a Website ColumnEvery department is getting a web page. Add a column named `website` of type `TE... | easy | ○ Not Started | ALTER & DROP | Solve |
| 19 | Add a Column With a DefaultTrack how many credits each student has earned so far. Add a column `credits_ear... | easy | ○ Not Started | ALTER & DROP | Solve |
| 20 | Add a Required ColumnCourses need a flag saying whether they run online. Add `is_online` to `courses`... | easy | ○ Not Started | ALTER & DROP | Solve |
| 21 | Rename the City ColumnThe `city` column in `students` is really the student's home town, so rename it ... | easy | ○ Not Started | ALTER & DROP | Solve |
| 22 | Drop the Notes ColumnThe free-text `notes` column on `enrollments` is no longer wanted. Remove it wit... | medium | ○ Not Started | ALTER & DROP | Solve |
| 23 | Rename the Departments TableThe college now calls its departments faculties. Rename the whole `departments` ... | medium | ○ Not Started | ALTER & DROP | Solve |
| 24 | Drop Tables SafelyRemove the `enrollments` table from this database, and also remove a `clubs` tab... | medium | ○ Not Started | ALTER & DROP | Solve |
| 25 | Migrate the Instructors TableApply a four-step migration to `instructors` in one script: add `middle_name` as... | hard | ○ Not Started | ALTER & DROP | Solve |