How many swimmers are there with record?
select count ( distinct swimmer_id ) from record
How about swimmers with no record?
select count ( * ) from swimmer where id not in ( select swimmer_id from record )
What their names?
select name from swimmer where id not in ( select swimmer_id from record )