How many totals are there for players with an average under 8 and less than 4 matches?
CREATE TABLE "season" (
  "rank" real,
  "player" text,
  "county" text,
  "tally" text,
  "total" real,
  "matches" real,
  "average" real
);
SELECT COUNT("total") FROM "season" WHERE "average"<8 AND "matches"<4;