What was the highest Interview score from a contestant who had a swimsuit score of 8.857 and an Average score over 9.097?
CREATE TABLE table_name_66 (interview INTEGER, swimsuit VARCHAR, average VARCHAR)
SELECT MAX(interview) FROM table_name_66 WHERE swimsuit = 8.857 AND average > 9.097
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_66 (interview INTEGER, swimsuit VARCHAR, average VARCHAR) Question: What was the highest Interview score from a contestant who had a swimsuit score of 8.857 and an Average score over 9.097? [/INST] SELECT MAX(interview) FROM table_name_66 WHERE swimsuit = 8.857 AND average > 9.097 </s>