What is the average interview score of a contestant from Louisiana with an evening gown smaller than 8.82?
CREATE TABLE "preliminary_competition" (
  "state" text,
  "interview" real,
  "swimsuit" real,
  "evening_gown" real,
  "average" real
);
SELECT AVG("interview") FROM "preliminary_competition" WHERE "evening_gown"<8.82 AND "state"='louisiana';