Table: miss_usa_1990_scores
Columns: state
interview
swimsuit
evening_gown
average

Question: Name the total number of swimsuits when evening gown is 8.329 and average is less than 8.497
SQL: SELECT COUNT("swimsuit") FROM miss_usa_1990_scores WHERE "evening_gown" = 8.329 AND "average" < 8.497

Question: Name the sum of swimsuit when the evening gown is less than 6.983 and the average is less than 7.362
SQL: SELECT SUM("swimsuit") FROM miss_usa_1990_scores WHERE "average" < 7.362 AND "evening_gown" < 6.983

Question: Name the most interview for minnesota and average more than 7.901
SQL: SELECT MAX("interview") FROM miss_usa_1990_scores WHERE "state" = 'minnesota' AND "average" > 7.901