Name the most other apps for league goals being 1
CREATE TABLE table_2979789_1 (other_apps INTEGER, league_goals VARCHAR)
SELECT MAX(other_apps) FROM table_2979789_1 WHERE league_goals = 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2979789_1 (other_apps INTEGER, league_goals VARCHAR) Question: Name the most other apps for league goals being 1 [/INST] SELECT MAX(other_apps) FROM table_2979789_1 WHERE league_goals = 1 </s>