What is the average total value in a League less than 1 with more than 1 League Cup?
CREATE TABLE "goalscorers" (
  "name" text,
  "league" real,
  "fa_cup" real,
  "league_cup" real,
  "total" real
);
SELECT AVG("total") FROM "goalscorers" WHERE "league"<1 AND "league_cup">1;