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

Question: It has fa cup goals larger than 0 and total goals of 0, what is the average total apps?
SQL: SELECT AVG("total_apps") FROM george_utley WHERE "total_goals" = 0 AND "fa_cup_goals" > 0

Question: It has a FA Cup Goals smaller than 4, and a FA Cup Apps larger than 7, what is the total number of total apps?
SQL: SELECT COUNT("total_apps") FROM george_utley WHERE "fa_cup_goals" < 4 AND "fa_cup_apps" > 7

Question: The total goals have a FA Cup Apps larger than 1, and a Total Apps of 37, and a League Apps smaller than 30?, what is the total number?
SQL: SELECT COUNT("total_goals") FROM george_utley WHERE "fa_cup_apps" > 1 AND "total_apps" = 37 AND "league_apps" < 30