Table: geelong_players
Columns: debut_year
player
date_of_birth
games
goals
years_at_club

Question: How many games for keith j. miller, who debuted after 1974 with less than 1 goal?
SQL: SELECT AVG("games") FROM geelong_players WHERE "goals" < 1 AND "player" = 'keith j. miller' AND "debut_year" > 1974