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?
CREATE TABLE "preliminary_competition" (
  "state" text,
  "swimsuit" real,
  "evening_gown" real,
  "interview" real,
  "average" real
);
SELECT "state" FROM "preliminary_competition" WHERE "average"<8.67 AND "swimsuit"=8.27 AND "evening_gown"=8.78 AND "interview"=8.52;