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

What is the average Bronze for rank 3 and total is more than 8?
SELECT AVG("Bronze") FROM table_76079 WHERE "Rank" = '3' AND "Total" > '8'
SELECT AVG("Bronze") FROM "table_76079" WHERE "Rank" = '3' AND "Total" > '8'