CREATE TABLE table_name_26 (gold VARCHAR, bronze VARCHAR, silver VARCHAR, total VARCHAR)

How much Gold has a Silver smaller than 3, and a Total of 9, and a Bronze smaller than 1?
SELECT COUNT(gold) FROM table_name_26 WHERE silver < 3 AND total = 9 AND bronze < 1
SELECT COUNT("gold") FROM "table_name_26" WHERE "bronze" < 1 AND "silver" < 3 AND "total" = 9