Which FA Cup apps has league goals of 1 with total goals less than 1?
CREATE TABLE "barnsley" (
  "division" text,
  "league_apps" real,
  "league_goals" real,
  "fa_cup_apps" real,
  "fa_cup_goals" real,
  "total_apps" real,
  "total_goals" real
);
SELECT AVG("fa_cup_apps") FROM "barnsley" WHERE "league_goals"=1 AND "total_goals"<1;