Find the names of the swimmers who have no record.
CREATE TABLE swimmer (name VARCHAR, id VARCHAR, swimmer_id VARCHAR); CREATE TABLE record (name VARCHAR, id VARCHAR, swimmer_id VARCHAR)
SELECT name FROM swimmer WHERE NOT id IN (SELECT swimmer_id FROM record)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE swimmer (name VARCHAR, id VARCHAR, swimmer_id VARCHAR); CREATE TABLE record (name VARCHAR, id VARCHAR, swimmer_id VARCHAR) Question: Find the names of the swimmers who have no record. [/INST] SELECT name FROM swimmer WHERE NOT id IN (SELECT swimmer_id FROM record) </s>