Table schema:
CREATE TABLE table_name_64 (apps INTEGER, country VARCHAR, goals VARCHAR)

Question: What is the average Apps of indonesia with Goals smaller than 1000?
SQL: SELECT AVG(apps) FROM table_name_64 WHERE country = "indonesia" AND goals < 1000