What is the average total in the county of tipperary with a rank less than 1?
CREATE TABLE "season" (
  "rank" real,
  "player" text,
  "county" text,
  "tally" text,
  "total" real,
  "matches" real,
  "average" real
);
SELECT COUNT("average") FROM "season" WHERE "county"='tipperary' AND "rank"<1;