Find the names of the swimmers who have no record.
create table swimmer (name varchar, id varchar, swimmer_id varchar, PRIMARY KEY (name)); create table record (name varchar, id varchar, swimmer_id varchar, PRIMARY KEY (name))
select name from swimmer where not id in (select swimmer_id from record)