Table: miss_usa_1990_scores
Columns: state
interview
swimsuit
evening_gown
average

Question: Which smallest swimsuit number's interview was less than 8.574 when the average number was bigger than 8.532?
SQL: SELECT MIN("swimsuit") FROM miss_usa_1990_scores WHERE "interview" < 8.574 AND "average" > 8.532

Question: Which smallest interview number had a swimsuit stat of less than 9.322, an evening gown score of more than 9.259, and an average number of 9.321?
SQL: SELECT MIN("interview") FROM miss_usa_1990_scores WHERE "swimsuit" < 9.322 AND "evening_gown" > 9.259 AND "average" = 9.321

Question: What is the highest mean number for Texas when the swimsuit stat was more than 8.839?
SQL: SELECT MAX("average") FROM miss_usa_1990_scores WHERE "state" = 'texas' AND "swimsuit" > 8.839

Question: What is the mean evening gown number when the average is 8.686?
SQL: SELECT AVG("evening_gown") FROM miss_usa_1990_scores WHERE "average" = 8.686

Question: What is the sum number of evening gown stats for New Jersey when the interview was less than 9.344?
SQL: SELECT COUNT("evening_gown") FROM miss_usa_1990_scores WHERE "state" = 'new jersey' AND "interview" < 9.344