How many totals have a Premier League smaller than 6, and a League Cup larger than 0?
CREATE TABLE "goalscorers" (
  "name" text,
  "premier_league" real,
  "league_cup" real,
  "fa_cup" real,
  "uefa_cup" real,
  "total" real
);
SELECT SUM("total") FROM "goalscorers" WHERE "premier_league"<6 AND "league_cup">0;