CREATE TABLE table_10039 ("Name" CLOB, "Country" CLOB, "Transfer window" CLOB, "Transfer fee" CLOB, "Apps" FLOAT, "Goals" FLOAT)

what is the apps when the name is smith?
SELECT MIN("Apps") FROM table_10039 WHERE "Name" = 'smith'
SELECT MIN("Apps") FROM "table_10039" WHERE "Name" = 'smith'