How many league cup goals on average for players with over 0 FA cup and 5 league goals?
CREATE TABLE table_name_64 (league INTEGER, fa_cup VARCHAR)
SELECT AVG(league) AS Cup FROM table_name_64 WHERE fa_cup > 0 AND league = 5
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_64 (league INTEGER, fa_cup VARCHAR) Question: How many league cup goals on average for players with over 0 FA cup and 5 league goals? [/INST] SELECT AVG(league) AS Cup FROM table_name_64 WHERE fa_cup > 0 AND league = 5 </s>