SCHEMA:
CREATE TABLE table_name_34 (goals INTEGER, club VARCHAR, apps VARCHAR)
USER:
Name the most goals for total club and apps less than 120

QUERY:
SELECT MAX(goals) FROM table_name_34 WHERE club = "total" AND apps < 120