SELECT name FROM swimmer WHERE NOT id IN (SELECT swimmer_id FROM record)
Temukan nama perenang yang tidak memiliki catatan.
CREATE TABLE swimmer (name VARCHAR, id VARCHAR, swimmer_id VARCHAR); CREATE TABLE record (name VARCHAR, id VARCHAR, swimmer_id VARCHAR)