CREATE TABLE table_name_15 (player VARCHAR, opponent VARCHAR, team VARCHAR)

What richmond player played against st kilda?
SELECT player FROM table_name_15 WHERE opponent = "st kilda" AND team = "richmond"
SELECT "player" FROM "table_name_15" WHERE "opponent" = "st kilda" AND "richmond" = "team"