user: ### NOW ANSWER:
Question: Which Goals have Apps smaller than 1?
Columns: ['National team', 'Club', 'Year', 'Apps', 'Goals']
Types: ['text', 'text', 'text', 'real', 'real']
Sample row: ['England', 'Arsenal', '2010', 1.0, 0.0]
SQL:

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