Students Who Never Enrolled

Three students joined in 2026 and have not enrolled in anything yet. Find them with a join (no subquery): return first_name, last_name and enrollment_year, sorted by last_name.

Expected result:

+------------+-----------+-----------------+
| first_name | last_name | enrollment_year |
+------------+-----------+-----------------+
| Zoe        | Campbell  |            2026 |
| Leo        | Martin    |            2026 |
| Aiden      | Rahman    |            2026 |
+------------+-----------+-----------------+
3 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.