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

With 8 as the rank, and a total of more than 2 medals what is the average bronze medals?
SELECT AVG("Bronze") FROM table_58924 WHERE "Rank" = '8' AND "Total" > '2'
SELECT AVG("Bronze") FROM "table_58924" WHERE "Rank" = '8' AND "Total" > '2'