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

What was Italy's highest total when there were less than 4 bronze and 1 gold?
SELECT MAX("Total") FROM table_39845 WHERE "Bronze" < '4' AND "Gold" = '1' AND "Nation" = 'italy'
SELECT MAX("Total") FROM "table_39845" WHERE "Bronze" < '4' AND "Gold" = '1' AND "Nation" = 'italy'