CREATE TABLE table_name_23 (rank INT, gold VARCHAR, total VARCHAR, bronze VARCHAR, silver VARCHAR)

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_name_23 WHERE bronze > 0 AND silver = 8 AND total = 19 AND gold < 9
SELECT MIN("rank") FROM "table_name_23" WHERE "bronze" > 0 AND "gold" < 9 AND "silver" = 8 AND "total" = 19