SELECT name FROM instructor WHERE id NOT IN (SELECT id FROM teaches)
What are the names of instructors who didn't teach?
SELECT name FROM instructor WHERE id NOT IN ( SELECT id FROM teaches )
select name from instructor where id not in ( select id from teaches )
What are the names of instructors who did n't teach ?