How many swimming records are there?
select count(*) from record
How many of them have a result of win?
select count(*) from record where result = 'Win'
Show me the swimmer ids in those records.
select swimmer_id from record where result = 'Win'
What are their names?
select t1.name from swimmer as t1 join record as t2 on t1.id = t2.swimmer_id where result = 'Win'