Table: football_stats_12
Columns: season
division
league_apps
league_goals
fa_cup_apps
fa_cup_goals
other_apps
other_goals
total_apps
total_goals

Question: Name the most other apps for league goals being 1
SQL: SELECT MAX("other_apps") FROM football_stats_12 WHERE "league_goals" = 1

Question: Name the most fa cup apps for league apps being 27
SQL: SELECT MAX("fa_cup_apps") FROM football_stats_12 WHERE "league_apps" = 27

Question: Name the total number of division for fa cups being 9
SQL: SELECT COUNT("division") FROM football_stats_12 WHERE "fa_cup_apps" = 9