question: Which Total Goals have Total Apps of 42 (3), and League Goals smaller than 1?
answer: SELECT MAX(total_goals) FROM table_name_10 WHERE total_apps = "42 (3)" AND league_goals < 1
context: CREATE TABLE table_name_10 (total_goals INTEGER, total_apps VARCHAR, league_goals VARCHAR)