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

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")