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

What's the average total if the Bronze is 5 and the Silver is less than 4?
SELECT AVG("Total") FROM table_70571 WHERE "Bronze" = '5' AND "Silver" < '4'
SELECT AVG("Total") FROM "table_70571" WHERE "Bronze" = '5' AND "Silver" < '4'