Winter Roster as a View

Create a view called winter_roster with one row per enrollment in a course that runs in 'Winter 2026'. It must have exactly three columns: course (the course code), student (the student's first_name and last_name joined with a single space, e.g. Ava Patel) and enrolled_on. Join enrollments to students and courses to get there. Leave the SELECT at the bottom in place: it lists the view sorted by course, then student.

Expected result:

Table winter_roster
✓ course TEXT
✓ student (no type)
✓ enrolled_on TEXT

+--------+----------------+-------------+
| course | student        | enrolled_on |
+--------+----------------+-------------+
| BIO305 | Amelia Schmidt | 2025-12-04  |
| BIO305 | Harper Singh   | 2025-12-05  |
| BIO305 | Henry Adeyemi  | 2025-12-09  |
| BIO305 | Jack Thompson  | 2025-12-11  |
| BUS320 | Abigail Larsen | 2025-12-08  |
| BUS320 | Daniel Osei    | 2025-12-10  |
| CS201  | Abigail Larsen | 2026-01-12  |
| CS201  | Ava Patel      | 2025-12-01  |
| CS201  | James Mensah   | 2025-12-08  |
| CS201  | Liam Nguyen    | 2025-12-01  |
+--------+----------------+-------------+
(showing 10 of 35 rows)

Hints3 available

Topics:

Views & Indexes

Code Editor

Tab to indent (Esc then Tab to move on) · Ctrl+Enter to run · Ctrl+Space to expand shortcuts (sel, ins, desc)

Results

Run your SQL to see every statement's output here, then how it compares with the expected answer.

Not sure what is in a table? SHOW TABLES lists them and DESCRIBE students shows the columns — or open the database browser on the left.