CREATE TABLE table_name_99 (player VARCHAR2, position VARCHAR2, team VARCHAR2)

who is the player when the position is p and the team is oakland athletics?
SELECT player FROM table_name_99 WHERE position = "p" AND team = "oakland athletics"
SELECT "player" FROM "table_name_99" WHERE "oakland athletics" = "team" AND "p" = "position"