I want the average for evening gown of 7.52 and swimsuit larger than 7.78
CREATE TABLE table_name_54 (average INTEGER, evening_gown VARCHAR, swimsuit VARCHAR)
SELECT AVG(average) FROM table_name_54 WHERE evening_gown = 7.52 AND swimsuit > 7.78
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_54 (average INTEGER, evening_gown VARCHAR, swimsuit VARCHAR) Question: I want the average for evening gown of 7.52 and swimsuit larger than 7.78 [/INST] SELECT AVG(average) FROM table_name_54 WHERE evening_gown = 7.52 AND swimsuit > 7.78 </s>