user: ### NOW ANSWER:
Question: Tell me the highest league goals with total goals less than 1 and FA cups more than 0
Columns: ['Squad No.', 'Name', 'Position', 'League Apps', 'League Goals', 'FA Cup Apps', 'FA Cup Goals', 'League Cup Apps', 'League Cup Goals', 'FLT Apps', 'FLT Goals', 'Total Apps', 'Total Goals']
Types: ['real', 'text', 'text', 'text', 'real', 'text', 'real', 'text', 'real', 'text', 'real', 'text', 'real']
Sample row: [2.0, 'Andy Holdsworth', 'DF', '43 (1)', 3.0, '5', 0.0, '0', 0.0, '1', 0.0, '49 (1)', 3.0]
SQL:

assistant: SELECT MAX("League Goals") FROM "Table" WHERE "Total Goals" < 1.0 AND "FA Cup Goals" > 0.0;