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

I want the average bronze for total of 19 and silver of 8 with rank of 31
SELECT AVG("Bronze") FROM table_31960 WHERE "Total" = '19' AND "Silver" = '8' AND "Rank" = '31'
SELECT AVG("Bronze") FROM "table_31960" WHERE "Rank" = '31' AND "Silver" = '8' AND "Total" = '19'