CREATE TABLE table_10042 ("Name" TEXT, "Country" TEXT, "Transfer window" TEXT, "Transfer fee" TEXT, "Apps" FLOAT, "Goals" FLOAT)

what is the goals when the country is wal, the name is smith and apps is more than 0?
SELECT SUM("Goals") FROM table_10042 WHERE "Country" = 'wal' AND "Name" = 'smith' AND "Apps" > '0'
SELECT SUM("Goals") FROM "table_10042" WHERE "Apps" > '0' AND "Country" = 'wal' AND "Name" = 'smith'