What was the record at the game that had a loss of Brandon (4–8)?
CREATE TABLE table_name_86 (record VARCHAR, loss VARCHAR)
SELECT record FROM table_name_86 WHERE loss = "brandon (4–8)"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_86 (record VARCHAR, loss VARCHAR) Question: What was the record at the game that had a loss of Brandon (4–8)? [/INST] SELECT record FROM table_name_86 WHERE loss = "brandon (4–8)" </s>