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