user: ### NOW ANSWER:
Question: What is the lowest average that has a swimsuit less than 8.966, for west virginia and an evening gown less than 8.711?
Columns: ['State', 'Interview', 'Swimsuit', 'Evening Gown', 'Average']
Types: ['text', 'real', 'real', 'real', 'real']
Sample row: ['New York', 9.155, 9.394, 9.494, 9.347]
SQL:

assistant: SELECT MIN("Average") FROM "Table" WHERE "Swimsuit" < 8.966 AND "State" = 'west virginia' AND "Evening Gown" < 8.711;