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

Find the names of swimmers who has a result of 'win'.
SELECT t1.name FROM swimmer AS t1 JOIN record AS t2 ON t1.id = t2.swimmer_id WHERE RESULT = 'Win'
SELECT "t1"."name" FROM "swimmer" "t1" JOIN "record" "t2" ON "t1"."id" = "t2"."swimmer_id" WHERE "RESULT" = 'Win'