Find the name of dorms that do not have any amenity
CREATE TABLE dorm (dorm_name VARCHAR, dormid VARCHAR); CREATE TABLE has_amenity (dorm_name VARCHAR, dormid VARCHAR)
SELECT dorm_name FROM dorm WHERE NOT dormid IN (SELECT dormid FROM has_amenity)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE dorm (dorm_name VARCHAR, dormid VARCHAR); CREATE TABLE has_amenity (dorm_name VARCHAR, dormid VARCHAR) Question: Find the name of dorms that do not have any amenity [/INST] SELECT dorm_name FROM dorm WHERE NOT dormid IN (SELECT dormid FROM has_amenity) </s>