user: ### NOW ANSWER:
Question: What is the Average Finals Goals if the Total Goals is less than 1?
Columns: ['Player', 'Club', 'Qualifying Goals', 'Finals Goals', 'Total Goals']
Types: ['text', 'text', 'real', 'real', 'real']
Sample row: ['Stan Mortensen', 'Blackpool', 3.0, 1.0, 4.0]
SQL:

assistant: SELECT AVG("Finals Goals") FROM "Table" WHERE "Total Goals" < 1.0;