Courses No One Has Completed

Find the courses with no completed enrollment on record: the winter courses still in progress plus ART140, which nobody has taken. Return code and title, sorted by code. Use NOT EXISTS with a correlated subquery rather than a join.

Expected result:

+--------+----------------------+
| code   | title                |
+--------+----------------------+
| ART140 | Drawing Fundamentals |
| BIO305 | Genetics             |
| BUS320 | Financial Accounting |
| CS201  | Data Structures      |
| CS230  | Databases            |
| CS350  | Software Engineering |
| ENG250 | Modern Literature    |
+--------+----------------------+
7 rows

Hints3 available

Topics:

Subqueries

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.