CREATE TABLE table_name_34 (goals NUMBER, club VARCHAR2, apps VARCHAR2)

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