List the names of clubs that do not have any players.
CREATE TABLE player (name VARCHAR, Club_ID VARCHAR); CREATE TABLE CLub (name VARCHAR, Club_ID VARCHAR)
SELECT name FROM CLub WHERE NOT Club_ID IN (SELECT Club_ID FROM player)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE player (name VARCHAR, Club_ID VARCHAR); CREATE TABLE CLub (name VARCHAR, Club_ID VARCHAR) Question: List the names of clubs that do not have any players. [/INST] SELECT name FROM CLub WHERE NOT Club_ID IN (SELECT Club_ID FROM player) </s>