CREATE TABLE table_name_97 (total NUMBER, bronze VARCHAR2, sport VARCHAR2, gold VARCHAR2, silver VARCHAR2)

What is the lowest Total that has a Gold larger than 0, Silver smaller than 4, Sport of football, and a Bronze larger than 1?
SELECT MIN(total) FROM table_name_97 WHERE gold > 0 AND silver < 4 AND sport = "football" AND bronze > 1
SELECT MIN("total") FROM "table_name_97" WHERE "bronze" > 1 AND "football" = "sport" AND "gold" > 0 AND "silver" < 4