What's the highest Rank for the County of Offaly, the Player of Mark Corrigan, and the Total that is smaller than 8?
CREATE TABLE "single_game" (
  "rank" real,
  "player" text,
  "county" text,
  "tally" text,
  "total" real,
  "opposition" text
);
SELECT MAX("rank") FROM "single_game" WHERE "county"='offaly' AND "player"='mark corrigan' AND "total"<8;