CREATE TABLE table_65865 ("Rank" FLOAT, "Player" TEXT, "County" TEXT, "Tally" TEXT, "Total" FLOAT, "Opposition" TEXT)

What is the average rank of the match where offaly was the opposition and the total was greater than 9?
SELECT AVG("Rank") FROM table_65865 WHERE "Opposition" = 'offaly' AND "Total" > '9'
SELECT AVG("Rank") FROM "table_65865" WHERE "Opposition" = 'offaly' AND "Total" > '9'