Table: miss_teen_usa_1992
Columns: state
swimsuit
interview
evening_gown
average

Question: What is the lowest swimsuit score a contestant from Rhode Island with an average larger than 9.235 has?
SQL: SELECT MIN("swimsuit") FROM miss_teen_usa_1992 WHERE "state" = 'rhode island' AND "average" > 9.235

Question: What is the highest average a contestant from Iowa with a swimsuit smaller than 9.267 has?
SQL: SELECT MAX("average") FROM miss_teen_usa_1992 WHERE "state" = 'iowa' AND "swimsuit" < 9.267

Question: What is the highest average for a contestant with an evening gown larger than 9.449 from Kansas?
SQL: SELECT MAX("average") FROM miss_teen_usa_1992 WHERE "evening_gown" > 9.449 AND "state" = 'kansas'

Question: What is the lowest swimsuit for a contestant with an average of 9.125?
SQL: SELECT MIN("swimsuit") FROM miss_teen_usa_1992 WHERE "average" = 9.125

Question: What is the lowest interview for a contestant from North Carolina with a swimsuit larger than 9.021, an average smaller than 9.513, and an evening gown larger than 9.5?
SQL: SELECT MIN("interview") FROM miss_teen_usa_1992 WHERE "swimsuit" > 9.021 AND "average" < 9.513 AND "state" = 'north carolina' AND "evening_gown" > 9.5