Find the name of instructors who didn't teach any courses?
CREATE TABLE teaches (name VARCHAR, id VARCHAR); CREATE TABLE instructor (name VARCHAR, id VARCHAR)
SELECT name FROM instructor WHERE NOT id IN (SELECT id FROM teaches)
### Context: CREATE TABLE teaches (name VARCHAR, id VARCHAR); CREATE TABLE instructor (name VARCHAR, id VARCHAR) ### Question: Find the name of instructors who didn't teach any courses? ### Answer: SELECT name FROM instructor WHERE NOT id IN (SELECT id FROM teaches)