CREATE TABLE table_name_5 (player VARCHAR, total VARCHAR, opposition VARCHAR)

Which Player has a Total of 9, and an Opposition of offaly?
SELECT player FROM table_name_5 WHERE total = 9 AND opposition = "offaly"
SELECT "player" FROM "table_name_5" WHERE "offaly" = "opposition" AND "total" = 9