what is the goals when the country is wal, the name is smith and apps is more than 0?
CREATE TABLE table_name_83 (
    goals INTEGER,
    apps VARCHAR,
    country VARCHAR,
    name VARCHAR
)
SELECT SUM(goals) FROM table_name_83 WHERE country = "wal" AND name = "smith" AND apps > 0
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: what is the goals when the country is wal, the name is smith and apps is more than 0? ### Input: CREATE TABLE table_name_83 (
    goals INTEGER,
    apps VARCHAR,
    country VARCHAR,
    name VARCHAR
) ### Response: SELECT SUM(goals) FROM table_name_83 WHERE country = "wal" AND name = "smith" AND apps > 0