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

What is the largest total for a team with 1 bronze, 0 gold medals and ranking of 7?
SELECT MAX("Total") FROM table_78123 WHERE "Bronze" = '1' AND "Rank" = '7' AND "Gold" > '0'
SELECT MAX("Total") FROM "table_78123" WHERE "Bronze" = '1' AND "Gold" > '0' AND "Rank" = '7'