What's the highest swimsuit for an average less than 8.073, evening gown less than 8.31, and an interview over 8.23 in georgia?
CREATE TABLE "preliminary_competition" (
  "state" text,
  "interview" real,
  "swimsuit" real,
  "evening_gown" real,
  "average" real
);
SELECT MAX("swimsuit") FROM "preliminary_competition" WHERE "average"<8.073 AND "evening_gown"<8.31 AND "interview">8.23 AND "state"='georgia';