Table: miss_teen_usa_1988
Columns: state
interview
swimsuit
evening_gown
average

Question: What is the total for the state of new york and a swimsuit less than 9.394?
SQL: SELECT SUM("interview") FROM miss_teen_usa_1988 WHERE "state" = 'new york' AND "swimsuit" < 9.394

Question: What is the greatest interview that has a swimsuit less than 8.838?
SQL: SELECT MAX("interview") FROM miss_teen_usa_1988 WHERE "swimsuit" < 8.838

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?
SQL: SELECT MIN("average") FROM miss_teen_usa_1988 WHERE "swimsuit" < 8.966 AND "state" = 'west virginia' AND "evening_gown" < 8.711

Question: What is the lowest swimsuit that has an evening gown bigger than 8.794 for illinois?
SQL: SELECT MIN("swimsuit") FROM miss_teen_usa_1988 WHERE "evening_gown" > 8.794 AND "state" = 'illinois'