CREATE TABLE table_43924 ("Sport" TEXT, "Gold" FLOAT, "Silver" FLOAT, "Bronze" FLOAT, "Total" FLOAT)

How many gold values have totals over 30, bronzes over 35, and are in Swimming?
SELECT COUNT("Gold") FROM table_43924 WHERE "Total" > '30' AND "Sport" = 'swimming' AND "Bronze" > '35'
SELECT COUNT("Gold") FROM "table_43924" WHERE "Bronze" > '35' AND "Sport" = 'swimming' AND "Total" > '30'