How many cup goals for the season with more than 34 league apps?
CREATE TABLE table_name_9 (cup_goals INTEGER, league_apps INTEGER)
SELECT AVG(cup_goals) FROM table_name_9 WHERE league_apps > 34
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_9 (cup_goals INTEGER, league_apps INTEGER) Question: How many cup goals for the season with more than 34 league apps? [/INST] SELECT AVG(cup_goals) FROM table_name_9 WHERE league_apps > 34 </s>