SELECT name FROM swimmer WHERE id NOT IN (SELECT swimmer_id FROM record)
Find the names of the swimmers who have no record.
SELECT name FROM swimmer WHERE id NOT IN ( SELECT swimmer_id FROM record )
select name from swimmer where id not in ( select swimmer_id from record )
Find the names of the swimmers who have no record .