Table: miss_usa_1993_scores
Columns: state
interview
swimsuit
evening_gown
average

Question: What is the sum of the interview scores from North Dakota that have averages less than 8.697, evening gown scores less than 8.73, and swimsuit scores greater than 8.41?
SQL: SELECT SUM("interview") FROM miss_usa_1993_scores WHERE "average" < 8.697 AND "evening_gown" < 8.73 AND "state" = 'north dakota' AND "swimsuit" > 8.41

Question: What is the sum of the swimsuit scores from Missouri that have evening gown scores less than 8.77 and average scores less than 8.823?
SQL: SELECT SUM("swimsuit") FROM miss_usa_1993_scores WHERE "evening_gown" < 8.77 AND "state" = 'missouri' AND "average" < 8.823

Question: What is the total number of swimsuit scores that have average scores less than 8.823, evening gown scores less than 8.69, and interview scores equal to 8.27?
SQL: SELECT COUNT("swimsuit") FROM miss_usa_1993_scores WHERE "average" < 8.823 AND "evening_gown" < 8.69 AND "interview" = 8.27

Question: What is the lowest swimsuit score where the contestant scored less than 8.56 in the interview and greater than 8.54 in the evening gown?
SQL: SELECT MIN("swimsuit") FROM miss_usa_1993_scores WHERE "interview" < 8.56 AND "evening_gown" > 8.54

Question: What is the sum of the evening gown scores where the interview score is less than 8.77, the swimsuit score is equal to 7.8, and the average score is less than 8.2?
SQL: SELECT SUM("evening_gown") FROM miss_usa_1993_scores WHERE "interview" < 8.77 AND "swimsuit" = 7.8 AND "average" < 8.2