What are the names of teams that do no have match season record?
CREATE TABLE match_season (Name VARCHAR, Team_id VARCHAR, Team VARCHAR); CREATE TABLE team (Name VARCHAR, Team_id VARCHAR, Team VARCHAR)
SELECT Name FROM team WHERE NOT Team_id IN (SELECT Team FROM match_season)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE match_season (Name VARCHAR, Team_id VARCHAR, Team VARCHAR); CREATE TABLE team (Name VARCHAR, Team_id VARCHAR, Team VARCHAR) Question: What are the names of teams that do no have match season record? [/INST] SELECT Name FROM team WHERE NOT Team_id IN (SELECT Team FROM match_season) </s>