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

What is the rank for total less than 5, 1 bronze and less than 1 silver?
SELECT AVG("Rank") FROM table_12954 WHERE "Total" < '5' AND "Bronze" = '1' AND "Silver" < '1'
SELECT AVG("Rank") FROM "table_12954" WHERE "Bronze" = '1' AND "Silver" < '1' AND "Total" < '5'