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

What is the largest bronze with a Rank of 2, and a Gold smaller than 8?
SELECT MAX("Bronze") FROM table_5454 WHERE "Rank" = '2' AND "Gold" < '8'
SELECT MAX("Bronze") FROM "table_5454" WHERE "Gold" < '8' AND "Rank" = '2'