What is the average Apps of indonesia with Goals smaller than 1000?
CREATE TABLE "club" (
  "season" text,
  "team" text,
  "country" text,
  "division" text,
  "apps" real,
  "goals" real
);
SELECT AVG("apps") FROM "club" WHERE "country"='indonesia' AND "goals"<1000;