CREATE TABLE table_name_83 (player VARCHAR2, total VARCHAR2, opposition VARCHAR2)

What Player in Opposition of Kilkenny has a Total of 10?
SELECT player FROM table_name_83 WHERE total = 10 AND opposition = "kilkenny"
SELECT "player" FROM "table_name_83" WHERE "kilkenny" = "opposition" AND "total" = 10