what is the total number of opponent where date is november 23, 1980
CREATE TABLE table_11406866_2 (opponent VARCHAR, date VARCHAR)
SELECT COUNT(opponent) FROM table_11406866_2 WHERE date = "November 23, 1980"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_11406866_2 (opponent VARCHAR, date VARCHAR) Question: what is the total number of opponent where date is november 23, 1980 [/INST] SELECT COUNT(opponent) FROM table_11406866_2 WHERE date = "November 23, 1980" </s>