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

What is the lowest Rank with more than 0 bronze, 8 silver, and a total of 19, with less than 9 gold?
SELECT MIN("Rank") FROM table_7028 WHERE "Bronze" > '0' AND "Silver" = '8' AND "Total" = '19' AND "Gold" < '9'
SELECT MIN("Rank") FROM "table_7028" WHERE "Bronze" > '0' AND "Gold" < '9' AND "Silver" = '8' AND "Total" = '19'