CREATE TABLE table_name_15 (average INT, evening_gown VARCHAR, swimsuit VARCHAR, state VARCHAR)

What is the lowest average that has a swimsuit less than 8.966, for west virginia and an evening gown less than 8.711?
SELECT MIN(average) FROM table_name_15 WHERE swimsuit < 8.966 AND state = "west virginia" AND evening_gown < 8.711
SELECT MIN("average") FROM "table_name_15" WHERE "evening_gown" < 8.711 AND "state" = "west virginia" AND "swimsuit" < 8.966