CREATE TABLE table_64042 ("Name" CLOB, "Pre-Season" FLOAT, "A-League" FLOAT, "Finals" FLOAT, "Total" FLOAT)

Which Finals have a Pre-Season larger than 0?
SELECT MIN("Finals") FROM table_64042 WHERE "Pre-Season" > '0'
SELECT MIN("Finals") FROM "table_64042" WHERE "Pre-Season" > '0'