Table schema:
CREATE TABLE table_name_34 (goals INTEGER, club VARCHAR, apps VARCHAR)

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