| Title | Topics | Action | |||
|---|---|---|---|---|---|
| 58 | A View of Active StudentsCreate a view called `active_students` that lists only the students whose `statu... | easy | ○ Not Started | Views & Indexes | Solve |
| 59 | Drop a ViewThe first statement in the editor creates a view called `on_leave_students`, a o... | easy | ○ Not Started | Views & Indexes | Solve |
| 60 | Index the Student Last NamesThe student search looks people up by surname, so speed it up: create an index c... | easy | ○ Not Started | Views & Indexes | Solve |
| 61 | Drop a Mistaken Unique IndexThe first statement in the editor creates a unique index called `idx_courses_roo... | easy | ○ Not Started | Views & Indexes | Solve |
| 62 | Winter Roster as a ViewCreate a view called `winter_roster` with one row per enrollment in a course tha... | medium | ○ Not Started | Views & Indexes | Solve |
| 63 | Unique Instructor NamesNo two instructors may share the same full name. Create a unique index called `i... | medium | ○ Not Started | Views & Indexes | Solve |
| 64 | Honour Roll From a ViewCreate a view called `student_averages` with one row per student who has at leas... | hard | ○ Not Started | Views & Indexes | Solve |
| 65 | Seats Left Per CourseTwo statements, then the `SELECT` already at the bottom. First, create an index ... | hard | ○ Not Started | Views & Indexes | Solve |