CREATE TABLE table_31793 ("Rank" FLOAT, "Nation" TEXT, "Gold" FLOAT, "Silver" FLOAT, "Bronze" FLOAT, "Total" FLOAT)

What is the average value of Bronze when silver is 0 and the total is less than 1?
SELECT AVG("Bronze") FROM table_31793 WHERE "Silver" = '0' AND "Total" < '1'
SELECT AVG("Bronze") FROM "table_31793" WHERE "Silver" = '0' AND "Total" < '1'