user: ### NOW ANSWER:
Question: Which state had an average of less than 8.67, a swimsuit score of 8.27, an evening gown score of 8.78, and an interview number of 8.52?
Columns: ['State', 'Swimsuit', 'Evening gown', 'Interview', 'Average']
Types: ['text', 'real', 'real', 'real', 'real']
Sample row: ['Alabama', 8.14, 8.91, 8.9, 8.65]
SQL:

assistant: SELECT "State" FROM "Table" WHERE "Average" < 8.67 AND "Swimsuit" = 8.27 AND "Evening gown" = 8.78 AND "Interview" = 8.52;