What is the average number of bronze medals when the team's silver are more than 1 but the total medals are less than 9?
CREATE TABLE "medal_count" (
  "rank" real,
  "nation" text,
  "gold" real,
  "silver" real,
  "bronze" real,
  "total" real
);
SELECT AVG("bronze") FROM "medal_count" WHERE "silver">1 AND "total"<9;