What is the total when gold is 1, and rank is more than 4, and bronze is 0?
CREATE TABLE "performances_by_nation" (
  "rank" real,
  "gold" real,
  "silver" real,
  "bronze" real,
  "total" real
);
SELECT COUNT("total") FROM "performances_by_nation" WHERE "gold"=1 AND "rank">4 AND "bronze"=0;