CREATE TABLE table_name_10 (total_goals NUMBER, total_apps VARCHAR2, league_goals VARCHAR2)

Which Total Goals have Total Apps of 42 (3), and League Goals smaller than 1?
SELECT MAX(total_goals) FROM table_name_10 WHERE total_apps = "42 (3)" AND league_goals < 1
SELECT MAX("total_goals") FROM "table_name_10" WHERE "42 (3)" = "total_apps" AND "league_goals" < 1