CREATE TABLE swimmer (name VARCHAR, id VARCHAR)
CREATE TABLE record (swimmer_id VARCHAR)

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" = 'Win' INTERSECT SELECT "t1"."name" FROM "swimmer" AS "t1" JOIN "record" AS "t2" ON "t1"."id" = "t2"."swimmer_id" WHERE "RESULT" = 'Loss'