What is the sum of the interview scores from North Dakota that have averages less than 8.697, evening gown scores less than 8.73, and swimsuit scores greater than 8.41?
CREATE TABLE "preliminary_competition" (
  "state" text,
  "interview" real,
  "swimsuit" real,
  "evening_gown" real,
  "average" real
);
SELECT SUM("interview") FROM "preliminary_competition" WHERE "average"<8.697 AND "evening_gown"<8.73 AND "state"='north dakota' AND "swimsuit">8.41;