How many gold values have totals over 30, bronzes over 35, and are in Swimming?
CREATE TABLE "by_sport" (
  "sport" text,
  "gold" real,
  "silver" real,
  "bronze" real,
  "total" real
);
SELECT COUNT("gold") FROM "by_sport" WHERE "total">30 AND "sport"='swimming' AND "bronze">35;