Find the id of instructors who didn't teach any courses?
CREATE TABLE teaches (id VARCHAR); CREATE TABLE instructor (id VARCHAR)
SELECT id FROM instructor EXCEPT SELECT id FROM teaches
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE teaches (id VARCHAR); CREATE TABLE instructor (id VARCHAR) Question: Find the id of instructors who didn't teach any courses? [/INST] SELECT id FROM instructor EXCEPT SELECT id FROM teaches </s>