What is the total number of swimsuit scores that have average scores less than 8.823, evening gown scores less than 8.69, and interview scores equal to 8.27?
CREATE TABLE "preliminary_competition" (
  "state" text,
  "interview" real,
  "swimsuit" real,
  "evening_gown" real,
  "average" real
);
SELECT COUNT("swimsuit") FROM "preliminary_competition" WHERE "average"<8.823 AND "evening_gown"<8.69 AND "interview"=8.27;