Table: player_stats_24
Columns: season
club
competition
apps
goals

Question: Name the most goals for total club and apps less than 120
SQL: SELECT MAX("goals") FROM player_stats_24 WHERE "club" = 'total' AND "apps" < 120