CREATE TABLE table_70569 ("Rank" FLOAT, "Nation" CLOB, "Gold" FLOAT, "Silver" FLOAT, "Bronze" FLOAT, "Total" FLOAT)

What's the lowest Gold if the Rank is over 4 but the Total is less than 1?
SELECT MIN("Gold") FROM table_70569 WHERE "Rank" > '4' AND "Total" < '1'
SELECT MIN("Gold") FROM "table_70569" WHERE "Rank" > '4' AND "Total" < '1'