What's the average interview with Preliminaries larger than 8.27, an Evening Gown of 8.85, and an Average smaller than 8.842?
CREATE TABLE "final_competition_scores" (
  "state" text,
  "preliminaries" real,
  "interview" real,
  "swimsuit" real,
  "evening_gown" real,
  "average" real
);
SELECT AVG("interview") FROM "final_competition_scores" WHERE "preliminaries">8.27 AND "evening_gown"=8.85 AND "average"<8.842;