CREATE TABLE table_name_17 (total VARCHAR2, silver VARCHAR2, country VARCHAR2, gold VARCHAR2)

How many times does Switzerland have under 7 golds and less than 3 silvers?
SELECT COUNT(total) FROM table_name_17 WHERE country = "switzerland" AND gold < 7 AND silver < 3
SELECT COUNT("total") FROM "table_name_17" WHERE "country" = "switzerland" AND "gold" < 7 AND "silver" < 3