Name the average total for gold less than 1 and rank less than 5
CREATE TABLE "performance_by_nation" (
  "rank" real,
  "gold" real,
  "silver" real,
  "bronze" real,
  "total" real
);
SELECT AVG("total") FROM "performance_by_nation" WHERE "gold"<1 AND "rank"<5;