What is the total swimsuit with Preliminaries smaller than 8.27?
CREATE TABLE "final_competition_scores" (
  "state" text,
  "preliminaries" real,
  "interview" real,
  "swimsuit" real,
  "evening_gown" real,
  "average" real
);
SELECT SUM("swimsuit") FROM "final_competition_scores" WHERE "preliminaries"<8.27;