user: ### NOW ANSWER:
Question: what is the goals when the country is wal, the name is smith and apps is more than 0?
Columns: ['Name', 'Country', 'Transfer window', 'Transfer fee', 'Apps', 'Goals']
Types: ['text', 'text', 'text', 'text', 'real', 'real']
Sample row: ['Forde', 'IRL', 'Summer', 'Free', 7.0, 0.0]
SQL:

assistant: SELECT SUM("Goals") FROM "Table" WHERE "Country" = 'wal' AND "Name" = 'smith' AND "Apps" > 0.0;