What is the sum of the Bronze medals when the Gold medals are larger than 0, Silver medals are smaller than 1, and the total is smaller than 1?
CREATE TABLE "medal_table" (
  "nation" text,
  "gold" real,
  "silver" real,
  "bronze" real,
  "total" real
);
SELECT SUM("bronze") FROM "medal_table" WHERE "gold">0 AND "silver"<1 AND "total"<1;