Show ids for the faculty members who don't advise any student.
CREATE TABLE Faculty (FacID VARCHAR, advisor VARCHAR); CREATE TABLE Student (FacID VARCHAR, advisor VARCHAR)
SELECT FacID FROM Faculty EXCEPT SELECT advisor FROM Student
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Faculty (FacID VARCHAR, advisor VARCHAR); CREATE TABLE Student (FacID VARCHAR, advisor VARCHAR) Question: Show ids for the faculty members who don't advise any student. [/INST] SELECT FacID FROM Faculty EXCEPT SELECT advisor FROM Student </s>