Show all track names that have had no races.
CREATE TABLE track (name VARCHAR, track_id VARCHAR); CREATE TABLE race (name VARCHAR, track_id VARCHAR)
SELECT name FROM track WHERE NOT track_id IN (SELECT track_id FROM race)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE track (name VARCHAR, track_id VARCHAR); CREATE TABLE race (name VARCHAR, track_id VARCHAR) Question: Show all track names that have had no races. [/INST] SELECT name FROM track WHERE NOT track_id IN (SELECT track_id FROM race) </s>