What is the average rank of the match where offaly was the opposition and the total was greater than 9?
CREATE TABLE "single_game" (
  "rank" real,
  "player" text,
  "county" text,
  "tally" text,
  "total" real,
  "opposition" text
);
SELECT AVG("rank") FROM "single_game" WHERE "opposition"='offaly' AND "total">9;