CREATE TABLE table_55468 ("Season" CLOB, "Club" CLOB, "Competition" CLOB, "Apps" FLOAT, "Goals" FLOAT)

Name the most goals for total club and apps less than 120
SELECT MAX("Goals") FROM table_55468 WHERE "Club" = 'total' AND "Apps" < '120'
SELECT MAX("Goals") FROM "table_55468" WHERE "Apps" < '120' AND "Club" = 'total'