CREATE TABLE table_name_55 (player VARCHAR, team VARCHAR)

WHAT PLAYER HAS THE OAKLAND ATHLETICS?
SELECT player FROM table_name_55 WHERE team = "oakland athletics"
SELECT "player" FROM "table_name_55" WHERE "oakland athletics" = "team"