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)
[SQL] SELECT name FROM swimmer WHERE NOT id IN (SELECT swimmer_id FROM record) [/SQL]