CREATE TABLE table_name_11 (player VARCHAR, opposition VARCHAR)

Which Player has an Opposition of clare?
SELECT player FROM table_name_11 WHERE opposition = "clare"
SELECT "player" FROM "table_name_11" WHERE "clare" = "opposition"