user: ### NOW ANSWER:
Question: What is the average Apps of Indonesia with Goals smaller than 1000?
Columns: ['Season', 'Team', 'Country', 'Division', 'Apps', 'Goals']
Types: ['text', 'text', 'text', 'text', 'real', 'real']
Sample row: ['2003', 'Traktor Tashkent', 'Uzbekistan', '1', 15.0, 11.0]
SQL:

assistant: SELECT AVG("Apps") FROM "Table" WHERE "Country" = 'Indonesia' AND "Goals" < 1000.0;