Table: miss_teen_usa_scores
Columns: state
preliminaries
interview
swimsuit
evening_gown
average

Question: What is the average evening gown score of the contestant from New York with a swimsuit score less than 8.703 and preliminaries larger than 8.292?
SQL: SELECT AVG("evening_gown") FROM miss_teen_usa_scores WHERE "swimsuit" < 8.703 AND "state" = 'new york' AND "preliminaries" > 8.292

Question: What is the preliminaries of the contestant from Massachusetts with an evening gown higher than 8.631, an average less than 8.791, and an interview higher than 8.608?
SQL: SELECT COUNT("preliminaries") FROM miss_teen_usa_scores WHERE "evening_gown" > 8.631 AND "average" < 8.791 AND "state" = 'massachusetts' AND "interview" > 8.608

Question: What is the preliminaries of the contestant with a swimsuit less than 8.948 and an interview of 8.997?
SQL: SELECT "preliminaries" FROM miss_teen_usa_scores WHERE "swimsuit" < 8.948 AND "interview" = 8.997

Question: What is the lowest interview of the contestant with an evening gown bigger than 9.343?
SQL: SELECT MIN("interview") FROM miss_teen_usa_scores WHERE "evening_gown" > 9.343

Question: What is the evening gown score of the contestant from the District of Columbia with preliminaries smaller than 8.647?
SQL: SELECT COUNT("evening_gown") FROM miss_teen_usa_scores WHERE "preliminaries" < 8.647 AND "state" = 'district of columbia'