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

What average total has 0 as the gold, with 6 as the rank?
SELECT AVG("Total") FROM table_79712 WHERE "Gold" = '0' AND "Rank" = '6'
SELECT AVG("Total") FROM "table_79712" WHERE "Gold" = '0' AND "Rank" = '6'