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'
Find the names of 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 '
select t1 . name from swimmer as t1 join record as t2 on t1 . id = t2 . swimmer_id where result = value intersect select t1 . name from swimmer as t1 join record as t2 on t1 . id = t2 . swimmer_id where result = value
Find the names of the swimmers who have both `` win '' and `` loss '' results in the record .