CREATE TABLE table_54864 ("Rank" FLOAT, "Nation" TEXT, "Gold" FLOAT, "Silver" FLOAT, "Bronze" FLOAT, "Total" FLOAT)

How many bronze's on average for nations with over 1 total, less than 2 golds, ranked 2nd?
SELECT AVG("Bronze") FROM table_54864 WHERE "Total" > '1' AND "Gold" < '2' AND "Rank" = '2'
SELECT AVG("Bronze") FROM "table_54864" WHERE "Gold" < '2' AND "Rank" = '2' AND "Total" > '1'