CREATE TABLE table_name_23 (total NUMBER, fa_cup_goals VARCHAR2, league_goals VARCHAR2)

Which Total has an FA Cup goals of 1, and a League goals of 4 + 7?
SELECT AVG(total) FROM table_name_23 WHERE fa_cup_goals = "1" AND league_goals = "4 + 7"
SELECT AVG("total") FROM "table_name_23" WHERE "1" = "fa_cup_goals" AND "4 + 7" = "league_goals"