WHich Evening Gown has a Swimsuit smaller than 7.99 and a Interview larger than 7.98?
CREATE TABLE "preliminaries_scores" (
  "province" text,
  "swimsuit" real,
  "evening_gown" real,
  "interview" real,
  "average" real
);
SELECT AVG("evening_gown") FROM "preliminaries_scores" WHERE "swimsuit"<7.99 AND "interview">7.98;