On November 2 what was the record of the team?
CREATE TABLE table_name_27 (record VARCHAR, date VARCHAR)
SELECT record FROM table_name_27 WHERE date = "november 2"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_27 (record VARCHAR, date VARCHAR) Question: On November 2 what was the record of the team? [/INST] SELECT record FROM table_name_27 WHERE date = "november 2" </s>