What is the name of the museum that had no visitor yet?
CREATE TABLE visit (name VARCHAR, Museum_ID VARCHAR, museum_id VARCHAR); CREATE TABLE museum (name VARCHAR, Museum_ID VARCHAR, museum_id VARCHAR)
SELECT name FROM museum WHERE NOT Museum_ID IN (SELECT museum_id FROM visit)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE visit (name VARCHAR, Museum_ID VARCHAR, museum_id VARCHAR); CREATE TABLE museum (name VARCHAR, Museum_ID VARCHAR, museum_id VARCHAR) Question: What is the name of the museum that had no visitor yet? [/INST] SELECT name FROM museum WHERE NOT Museum_ID IN (SELECT museum_id FROM visit) </s>