Table 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.
SQL: SELECT name FROM swimmer WHERE NOT id IN (SELECT swimmer_id FROM record)