CREATE TABLE table_name_28 (games INT, debut_year VARCHAR, goals VARCHAR, player VARCHAR)

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