Can you find me the names of all the swimmers who have "win" results in the record?
select t1.name from swimmer as t1 join record as t2 on t1.id = t2.swimmer_id where result = 'Win'
Can you find me the names of all the swimmers who have "loss" results in the record?
select t1.name from swimmer as t1 join record as t2 on t1.id = t2.swimmer_id where result = 'Loss'
Can you find me the names of all the swimmers who have both "win" and "loss" results in the record?
select t1.name from swimmer as t1 join record as t2 on t1.id = t2.swimmer_id where result = 'Win' intersect select t1.name from swimmer as t1 join record as t2 on t1.id = t2.swimmer_id where result = 'Loss'
What are these three swimmers' nationalities?
select t1.name, t1.nationality from swimmer as t1 join record as t2 on t1.id = t2.swimmer_id where result = 'Win' intersect select t1.name, t1.nationality from swimmer as t1 join record as t2 on t1.id = t2.swimmer_id where result = 'Loss'