How many finals had more than 0 goals and 8 assists?
CREATE TABLE table_name_14 (
    finals VARCHAR,
    goals VARCHAR,
    assists VARCHAR
)
SELECT finals FROM table_name_14 WHERE goals > 0 AND assists = 8
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: How many finals had more than 0 goals and 8 assists? ### Input: CREATE TABLE table_name_14 (
    finals VARCHAR,
    goals VARCHAR,
    assists VARCHAR
) ### Response: SELECT finals FROM table_name_14 WHERE goals > 0 AND assists = 8