CREATE TABLE table_60197 ("Rank" FLOAT, "Nation" CLOB, "Gold" FLOAT, "Silver" FLOAT, "Bronze" FLOAT, "Total" FLOAT)

What is the highest total when bronze is less than 1 and gold more than 0?
SELECT MAX("Total") FROM table_60197 WHERE "Bronze" < '1' AND "Gold" > '0'
SELECT MAX("Total") FROM "table_60197" WHERE "Bronze" < '1' AND "Gold" > '0'