How many averages had a swimsuit number of 8.42 and an evening gown number that was less than 8.71?
CREATE TABLE table_name_96 (average INTEGER, swimsuit VARCHAR, evening_gown VARCHAR)
SELECT SUM(average) FROM table_name_96 WHERE swimsuit = 8.42 AND evening_gown < 8.71
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_96 (average INTEGER, swimsuit VARCHAR, evening_gown VARCHAR) Question: How many averages had a swimsuit number of 8.42 and an evening gown number that was less than 8.71? [/INST] SELECT SUM(average) FROM table_name_96 WHERE swimsuit = 8.42 AND evening_gown < 8.71 </s>