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

What is the gold number when the total is 8 and bronze is more than 4?
SELECT AVG("Gold") FROM table_33938 WHERE "Total" = '8' AND "Bronze" > '4'
SELECT AVG("Gold") FROM "table_33938" WHERE "Bronze" > '4' AND "Total" = '8'