Find the names of stadiums which have never had any event.
CREATE TABLE stadium (name VARCHAR, id VARCHAR, stadium_id VARCHAR); CREATE TABLE event (name VARCHAR, id VARCHAR, stadium_id VARCHAR)
SELECT name FROM stadium WHERE NOT id IN (SELECT stadium_id FROM event)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE stadium (name VARCHAR, id VARCHAR, stadium_id VARCHAR); CREATE TABLE event (name VARCHAR, id VARCHAR, stadium_id VARCHAR) Question: Find the names of stadiums which have never had any event. [/INST] SELECT name FROM stadium WHERE NOT id IN (SELECT stadium_id FROM event) </s>