Which FA Cup has a Total smaller than 1?
CREATE TABLE "goalscorers" (
  "name" text,
  "premier_league" real,
  "league_cup" real,
  "fa_cup" real,
  "uefa_cup" real,
  "total" real
);
SELECT AVG("fa_cup") FROM "goalscorers" WHERE "total"<1;