How many averages had a swimsuit number of 8.42 and an evening gown number that was less than 8.71?
CREATE TABLE "preliminary_competition" (
  "state" text,
  "swimsuit" real,
  "evening_gown" real,
  "interview" real,
  "average" real
);
SELECT SUM("average") FROM "preliminary_competition" WHERE "swimsuit"=8.42 AND "evening_gown"<8.71;