CREATE TABLE instructor (name VARCHAR2, id VARCHAR2)
CREATE TABLE teaches (name VARCHAR2, id VARCHAR2)

Find the name of instructors who didn't teach any courses?
SELECT name FROM instructor WHERE NOT id IN (SELECT id FROM teaches)
SELECT "name" FROM "instructor" WHERE NOT "id" IN (SELECT "id" FROM "teaches")