CREATE TABLE table_name_33 (fa_cup_goals NUMBER, league_goals VARCHAR2, other_goals VARCHAR2, fl_cup_goals VARCHAR2)

What is the average FA Cup Goal value for players that have 0 Other goals, 0 FL Cup goals, and fewer than 39 League goals?
SELECT AVG(fa_cup_goals) FROM table_name_33 WHERE other_goals = 0 AND fl_cup_goals = 0 AND league_goals < 39
SELECT AVG("fa_cup_goals") FROM "table_name_33" WHERE "fl_cup_goals" = 0 AND "league_goals" < 39 AND "other_goals" = 0