Table: miss_usa_1995_scores
Columns: state
interview
swimsuit
evening_gown
average

Question: I want the average for evening gown of 7.52 and swimsuit larger than 7.78
SQL: SELECT AVG("average") FROM miss_usa_1995_scores WHERE "evening_gown" = 7.52 AND "swimsuit" > 7.78

Question: Tell me the lowest interview for oklahoma and swimsuit less than 8.8
SQL: SELECT MIN("interview") FROM miss_usa_1995_scores WHERE "state" = 'oklahoma' AND "swimsuit" < 8.8

Question: Tell me the sum of evening gown for average of 9.06 and swimsuit less than 8.76
SQL: SELECT SUM("evening_gown") FROM miss_usa_1995_scores WHERE "average" = 9.06 AND "swimsuit" < 8.76

Question: Tell me the highest interview for north carolina and evening gown more than 7.68
SQL: SELECT MAX("interview") FROM miss_usa_1995_scores WHERE "state" = 'north carolina' AND "evening_gown" > 7.68