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
names and nationalities of swimmers who have never won refers to selecting from swimmer table where there is no associated winning record in the record table;