On October 14, 1996 who was the opponent in the final?
CREATE TABLE table_name_47 (
    opponent_in_the_final VARCHAR,
    date VARCHAR
)
SELECT opponent_in_the_final FROM table_name_47 WHERE date = "october 14, 1996"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: On October 14, 1996 who was the opponent in the final? ### Input: CREATE TABLE table_name_47 (
    opponent_in_the_final VARCHAR,
    date VARCHAR
) ### Response: SELECT opponent_in_the_final FROM table_name_47 WHERE date = "october 14, 1996"