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)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: 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? [/INST] SELECT name FROM instructor WHERE NOT id IN (SELECT id FROM teaches) </s>