What was the highest average for the contestant having an interview score of 8.46?
CREATE TABLE table_name_84 (average INTEGER, interview VARCHAR)
SELECT MAX(average) FROM table_name_84 WHERE interview = 8.46
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_84 (average INTEGER, interview VARCHAR) Question: What was the highest average for the contestant having an interview score of 8.46? [/INST] SELECT MAX(average) FROM table_name_84 WHERE interview = 8.46 </s>