Who Teaches in Winter 2026

List every instructor teaching a course this winter. Return the instructor's first_name and last_name and the course code, one row per course, so an instructor with two winter courses appears twice. Only courses whose semester is 'Winter 2026' count. Sort by code.

Expected result:

+------------+-----------+---------+
| first_name | last_name | code    |
+------------+-----------+---------+
| Tomasz     | Nowak     | BIO305  |
| Daniel     | Reyes     | CS201   |
| Mei        | Chen      | CS230   |
| Daniel     | Reyes     | CS350   |
| Marcus     | Lindqvist | ENG250  |
| Priya      | Natarajan | MATH220 |
+------------+-----------+---------+
6 rows

Hints3 available

Topics:

Joins

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.