CREATE TABLE table_76555 ("Date" CLOB, "Captain 1" CLOB, "Team 2" CLOB, "Captain 2" CLOB, "Venue" CLOB, "Result" CLOB)

Which Captain 2 has a Result of final?
SELECT "Captain 2" FROM table_76555 WHERE "Result" = 'final'
SELECT "Captain 2" FROM "table_76555" WHERE "Result" = 'final'