user: ### NOW ANSWER:
Question: How many averages had a swimsuit number of 8.42 and an evening gown number that was less than 8.71?
Columns: ['State', 'Swimsuit', 'Evening gown', 'Interview', 'Average']
Types: ['text', 'real', 'real', 'real', 'real']
Sample row: ['Alabama', 8.14, 8.91, 8.9, 8.65]
SQL:

assistant: SELECT SUM("Average") FROM "Table" WHERE "Swimsuit" = 8.42 AND "Evening gown" < 8.71;