Name the most evening gown for average less than 8.793 with interview of 8.51 and swimsuit less than 8.12
CREATE TABLE table_name_38 (evening_gown INTEGER, interview VARCHAR, average VARCHAR, swimsuit VARCHAR)
SELECT MAX(evening_gown) FROM table_name_38 WHERE average < 8.793 AND swimsuit < 8.12 AND interview = 8.51
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_38 (evening_gown INTEGER, interview VARCHAR, average VARCHAR, swimsuit VARCHAR) Question: Name the most evening gown for average less than 8.793 with interview of 8.51 and swimsuit less than 8.12 [/INST] SELECT MAX(evening_gown) FROM table_name_38 WHERE average < 8.793 AND swimsuit < 8.12 AND interview = 8.51 </s>