Courses Nobody Is Taking

Find every course that has no enrollments at all. Return code and title, sorted by code. Use a join, not a subquery: the trick is to keep the courses that find no match in enrollments.

Expected result:

+--------+----------------------+
| code   | title                |
+--------+----------------------+
| ART140 | Drawing Fundamentals |
+--------+----------------------+
1 row

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.