What is the average total for less than 1 championship?
CREATE TABLE "yellow_cards" (
  "name" text,
  "championship" real,
  "league_cup" real,
  "fa_cup" real,
  "total" real
);
SELECT AVG("total") FROM "yellow_cards" WHERE "championship"<1;