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

What is the average medal total when the rank is less than 5 and less than 7 bronze medals were won?
SELECT AVG("Total") FROM table_13102 WHERE "Rank" < '5' AND "Bronze" < '7'
SELECT AVG("Total") FROM "table_13102" WHERE "Bronze" < '7' AND "Rank" < '5'