What is the Average Qualifying Goals for Jack Froggatt where the Final Goals is greater than 0?
CREATE TABLE table_name_3 (qualifying_goals INTEGER, player VARCHAR, finals_goals VARCHAR)
SELECT AVG(qualifying_goals) FROM table_name_3 WHERE player = "jack froggatt" AND finals_goals > 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_3 (qualifying_goals INTEGER, player VARCHAR, finals_goals VARCHAR) Question: What is the Average Qualifying Goals for Jack Froggatt where the Final Goals is greater than 0? [/INST] SELECT AVG(qualifying_goals) FROM table_name_3 WHERE player = "jack froggatt" AND finals_goals > 0 </s>