What is the sum of the swimsuit scores from Missouri that have evening gown scores less than 8.77 and average scores less than 8.823?
CREATE TABLE "preliminary_competition" (
  "state" text,
  "interview" real,
  "swimsuit" real,
  "evening_gown" real,
  "average" real
);
SELECT SUM("swimsuit") FROM "preliminary_competition" WHERE "evening_gown"<8.77 AND "state"='missouri' AND "average"<8.823;