Table: miss_usa_1992_scores
Columns: state
interview
swimsuit
evening_gown
average

Question: Which biggest interview score had an evening gown stat of 9.286?
SQL: SELECT MAX("interview") FROM miss_usa_1992_scores WHERE "evening_gown" = 9.286

Question: Which mean interview number had an average of more than 9.233, a swimsuit stat of more than 9.473, and an evening gown score of more than 9.671?
SQL: SELECT AVG("interview") FROM miss_usa_1992_scores WHERE "average" > 9.233 AND "swimsuit" = 9.473 AND "evening_gown" > 9.671

Question: Which is the smallest evening gown score when the interview score was more than 9.164, the swimsuit stat was less than 9.35, and the average is less than 9.233?
SQL: SELECT MIN("evening_gown") FROM miss_usa_1992_scores WHERE "interview" > 9.164 AND "swimsuit" < 9.35 AND "average" < 9.233

Question: Which is the largest average number when the swimsuit is 9.4 and the evening gown stat is less than 9.486?
SQL: SELECT MAX("average") FROM miss_usa_1992_scores WHERE "swimsuit" = 9.4 AND "evening_gown" < 9.486

Question: What is the total number of interview scores that have an evening gown score of 9.543 and an average that is bigger than 9.521?
SQL: SELECT SUM("interview") FROM miss_usa_1992_scores WHERE "evening_gown" = 9.543 AND "average" > 9.521

Question: What is the mean average score when the evening gown score is more than 9.35, the state is South Carolina, and the swimsuit score is more than 9.4?
SQL: SELECT AVG("average") FROM miss_usa_1992_scores WHERE "evening_gown" > 9.35 AND "state" = 'south carolina' AND "swimsuit" > 9.4