user: ### NOW ANSWER:
Question: Which Total Goals have Total Apps of 42 (3), and League Goals smaller than 1?
Columns: ['Name', 'Position', 'League Apps', 'League Goals', 'FA Cup Apps', 'FA Cup Goals', 'League Cup Apps', 'League Cup Goals', 'Total Apps', 'Total Goals']
Types: ['text', 'text', 'text', 'real', 'text', 'real', 'text', 'real', 'text', 'real']
Sample row: ['Terry Armstrong', 'FW', '4', 0.0, '0', 0.0, '0', 0.0, '4', 0.0]
SQL:

assistant: SELECT MAX("Total Goals") FROM "Table" WHERE "Total Apps" = '42 (3)' AND "League Goals" < 1.0;