What is the sum of the value "League Cup", when the Total is less than 1, and when the League is less than 0?
CREATE TABLE "appearances" (
  "name" text,
  "league" real,
  "fa_cup" real,
  "league_cup" real,
  "other" real,
  "total" real
);
SELECT SUM("league_cup") FROM "appearances" WHERE "total"<1 AND "league"<0;