What shows for gold when the rank is less than 3, and silver less than 1?
CREATE TABLE "performances_by_nation" (
  "rank" real,
  "gold" real,
  "silver" real,
  "bronze" real,
  "total" real
);
SELECT SUM("gold") FROM "performances_by_nation" WHERE "rank"<3 AND "silver"<1;