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

What is the average bronze with a rank of 4 and less than 1 silver?
SELECT AVG("Bronze") FROM table_71957 WHERE "Rank" = '4' AND "Silver" < '1'
SELECT AVG("Bronze") FROM "table_71957" WHERE "Rank" = '4' AND "Silver" < '1'