Can you list the names of all the swimmers who have won more than once?
select t1.name from swimmer as t1 join record as t2 on t1.id = t2.swimmer_id where result = 'Win' group by t2.swimmer_id having count ( * ) > 1
What are their nationalities?
select t1.nationality from swimmer as t1 join record as t2 on t1.id = t2.swimmer_id where result = 'Win' group by t2.swimmer_id having count ( * ) > 1
Can you list the names and nationalities of the swimmers who have never won?
select t1.name, t1.nationality from swimmer as t1 join record as t2 on t1.id = t2.swimmer_id where result = 'Win' except select t1.name, t1.nationality from swimmer as t1 join record as t2 on t1.id = t2.swimmer_id where result = 'Win' group by t2.swimmer_id having count ( * ) > 1