Table: george_utley
Columns: division
league_apps
league_goals
fa_cup_apps
fa_cup_goals
total_apps
total_goals

Question: Which FA Cup apps has league goals of 1 with total goals less than 1?
SQL: SELECT AVG("fa_cup_apps") FROM george_utley WHERE "league_goals" = 1 AND "total_goals" < 1

Question: What is the highest apps total with FA cup apps of 26 with total number of goals larger than 9?
SQL: SELECT MAX("total_apps") FROM george_utley WHERE "fa_cup_apps" = 26 AND "total_goals" > 9

Question: Which league goals has FA cup apps of 2?
SQL: SELECT "league_goals" FROM george_utley WHERE "fa_cup_apps" = 2

Question: What FA cup apps has a total larger than 12 and league apps larger than 38, and FA Cup goals larger than 1?
SQL: SELECT COUNT("fa_cup_apps") FROM george_utley WHERE "total_apps" > 12 AND "league_apps" > 38 AND "fa_cup_goals" > 1