CREATE TABLE table_name_5 (rank NUMBER, opposition VARCHAR2, total VARCHAR2)

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_name_5 WHERE opposition = "offaly" AND total > 9
SELECT AVG("rank") FROM "table_name_5" WHERE "offaly" = "opposition" AND "total" > 9