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"
<s>[INST] Write mssql query to answer the following question given the database schema. 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? [/INST] SELECT opponent_in_the_final FROM table_name_47 WHERE date = "october 14, 1996" </s>