user: Question: What is Division one's average Other Apps, with a League Goal less than 1?
Columns: ['Division', 'League Apps (Sub)', 'League Goals', 'FA Cup Apps (Sub)', 'FA Cup Goals', 'FL Cup Apps (Sub)', 'FL Cup Goals', 'Other Apps', 'Other Goals', 'Total Apps (Sub)', 'Total Goals']
Types: ['text', 'real', 'real', 'text', 'real', 'real', 'real', 'real', 'real', 'text', 'real']
Sample row: ['One', 13.0, 4.0, '0', 0.0, 0.0, 0.0, 2.0, 0.0, '15', 4.0]
SQL:

assistant: SELECT AVG("Other Apps") FROM "Table" WHERE "Division" = 'one' AND "League Goals" < 1.0;