Name the total number of division for fa cups being 9
CREATE TABLE table_2979789_1 (division VARCHAR, fa_cup_apps VARCHAR)
SELECT COUNT(division) FROM table_2979789_1 WHERE fa_cup_apps = 9
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2979789_1 (division VARCHAR, fa_cup_apps VARCHAR) Question: Name the total number of division for fa cups being 9 [/INST] SELECT COUNT(division) FROM table_2979789_1 WHERE fa_cup_apps = 9 </s>