How many swimming records are there?
select count(*) from record
Show me the swimmer ids associated with any of those record.
select distinct swimmer_id from record
What about the swimmer ids that are not one of those?
select id from swimmer where id not in (select swimmer_id from record)
Show me those swimmers' names.
select name from swimmer where id not in (select swimmer_id from record)