CREATE TABLE record (name VARCHAR, id VARCHAR, swimmer_id VARCHAR)
CREATE TABLE swimmer (name VARCHAR, id VARCHAR, swimmer_id VARCHAR)

Find the names of the swimmers who have no record.
SELECT name FROM swimmer WHERE NOT id IN (SELECT swimmer_id FROM record)
SELECT "name" FROM "swimmer" WHERE NOT "id" IN (SELECT "swimmer_id" FROM "record")