What is the gold number when the total is less than 8, silver less than 1 and the rank is more than 7?
CREATE TABLE "medals" (
  "rank" real,
  "nation" text,
  "gold" real,
  "silver" real,
  "bronze" real,
  "total" real
);
SELECT COUNT("gold") FROM "medals" WHERE "total"<8 AND "silver"<1 AND "rank">7;