CREATE TABLE table_name_75 (goals_for NUMBER, games_played NUMBER)

What is the average number of goals for games played that total more than 8?
SELECT AVG(goals_for) FROM table_name_75 WHERE games_played > 8
SELECT AVG("goals_for") FROM "table_name_75" WHERE "games_played" > 8