Table: miss_teen_usa_1997
Columns: state
interview
swimsuit
evening_gown
average

Question: What is the lowest evening gown score a contestant with an average less than 8.23, an interview score of 8.11, and a swimsuit larger than 7.84 has?
SQL: SELECT MIN("evening_gown") FROM miss_teen_usa_1997 WHERE "average" < 8.23 AND "interview" = 8.11 AND "swimsuit" > 7.84

Question: What is the total interview score a contestant from Indiana with an average smaller than 8.3 has?
SQL: SELECT COUNT("interview") FROM miss_teen_usa_1997 WHERE "state" = 'indiana' AND "average" < 8.3

Question: What is the highest swimsuit a contestant from Kansas with an average larger than 8.48, an interview higher than 8.58, and an evening gown higher than 8.82 has?
SQL: SELECT MAX("swimsuit") FROM miss_teen_usa_1997 WHERE "average" > 8.48 AND "interview" > 8.58 AND "evening_gown" > 8.82 AND "state" = 'kansas'

Question: What is the average interview score of a contestant from Louisiana with an evening gown smaller than 8.82?
SQL: SELECT AVG("interview") FROM miss_teen_usa_1997 WHERE "evening_gown" < 8.82 AND "state" = 'louisiana'