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