List the names of buildings that have no company office.
CREATE TABLE buildings (name VARCHAR, id VARCHAR, building_id VARCHAR); CREATE TABLE Office_locations (name VARCHAR, id VARCHAR, building_id VARCHAR)
SELECT name FROM buildings WHERE NOT id IN (SELECT building_id FROM Office_locations)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE buildings (name VARCHAR, id VARCHAR, building_id VARCHAR); CREATE TABLE Office_locations (name VARCHAR, id VARCHAR, building_id VARCHAR) Question: List the names of buildings that have no company office. [/INST] SELECT name FROM buildings WHERE NOT id IN (SELECT building_id FROM Office_locations) </s>