Which Finals has a A-League of 0 6, and a Pre-Season larger than 0?
CREATE TABLE table_name_12 (finals INTEGER, a_league VARCHAR, pre_season VARCHAR)
SELECT AVG(finals) FROM table_name_12 WHERE a_league = "0 6" AND pre_season > 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_12 (finals INTEGER, a_league VARCHAR, pre_season VARCHAR) Question: Which Finals has a A-League of 0 6, and a Pre-Season larger than 0? [/INST] SELECT AVG(finals) FROM table_name_12 WHERE a_league = "0 6" AND pre_season > 0 </s>