What's the total when the champions league was 0, the coppa italia was less than 0, and the Serie A was more than 1?
CREATE TABLE "goal_scorers" (
  "name" text,
  "serie_a" real,
  "champions_league" real,
  "coppa_italia" real,
  "total" real
);
SELECT SUM("total") FROM "goal_scorers" WHERE "champions_league"=0 AND "serie_a">1 AND "coppa_italia"<0;