CREATE TABLE table_name_89 (games NUMBER, years_at_club VARCHAR2, goals VARCHAR2)

Which Games have Years at club of 1974 1975, and Goals of 4?
SELECT AVG(games) FROM table_name_89 WHERE years_at_club = "1974–1975" AND goals = 4
SELECT AVG("games") FROM "table_name_89" WHERE "1974–1975" = "years_at_club" AND "goals" = 4