What is the lowest attendance for a stadium that has an average smaller than 307?
CREATE TABLE "stadia_and_attendances" (
  "team" text,
  "stadium" text,
  "capacity" real,
  "highest" real,
  "lowest" real,
  "average" real
);
SELECT AVG("lowest") FROM "stadia_and_attendances" WHERE "average"<307;