Which Captain 2 has a Result of final?
CREATE TABLE table_name_50 (captain_2 VARCHAR, result VARCHAR)
SELECT captain_2 FROM table_name_50 WHERE result = "final"
### Context: CREATE TABLE table_name_50 (captain_2 VARCHAR, result VARCHAR) ### Question: Which Captain 2 has a Result of final? ### Answer: SELECT captain_2 FROM table_name_50 WHERE result = "final"