Schema: CREATE TABLE table_name_47 (opponent_in_the_final VARCHAR, date VARCHAR)
Question: On October 14, 1996 who was the opponent in the final?
SQL: SELECT opponent_in_the_final FROM table_name_47 WHERE date = "october 14, 1996"