What are the average league goals that have 2 (1) as the total apps?
CREATE TABLE table_name_18 (league_goals INTEGER, total_apps VARCHAR)
SELECT AVG(league_goals) FROM table_name_18 WHERE total_apps = "2 (1)"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_18 (league_goals INTEGER, total_apps VARCHAR) Question: What are the average league goals that have 2 (1) as the total apps? [/INST] SELECT AVG(league_goals) FROM table_name_18 WHERE total_apps = "2 (1)" </s>