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