Which Rank has a Gold of 3, and a Bronze of 4, and a Total larger than 8?
CREATE TABLE "performances_by_nation" (
  "rank" real,
  "gold" real,
  "silver" real,
  "bronze" real,
  "total" real
);
SELECT MIN("rank") FROM "performances_by_nation" WHERE "gold"=3 AND "bronze"=4 AND "total">8;