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
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_14 (finals VARCHAR, goals VARCHAR, assists VARCHAR) Question: How many finals had more than 0 goals and 8 assists? [/INST] SELECT finals FROM table_name_14 WHERE goals > 0 AND assists = 8 </s>