user: Question: what is the average league cup goals when the league cup apps is 4, league goals is less than 4, fa cup apps is 1 and total apps is 35?
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', 'real', 'real', 'text', 'real']
Sample row: ['Terry Armstrong', 'FW', '17 (2)', 1.0, '0', 0.0, 0.0, 0.0, '17 (2)', 1.0]
SQL:

assistant: SELECT AVG("League Cup Goals") FROM "Table" WHERE "League Cup Apps" = 4.0 AND "League Goals" < 4.0 AND "FA Cup Apps" = '1' AND "Total Apps" = '35';