CREATE TABLE table_46744 ("Country" CLOB, "Amateur Era" FLOAT, "Open Era" FLOAT, "All-time" FLOAT, "First title" FLOAT, "Last title" FLOAT)

What is the lowest All-Time, when First Title is '2007, and when Amateur Era is greater than 0?
SELECT MIN("All-time") FROM table_46744 WHERE "First title" = '2007' AND "Amateur Era" > '0'
SELECT MIN("All-time") FROM "table_46744" WHERE "Amateur Era" > '0' AND "First title" = '2007'