CREATE TABLE table_name_6 (position VARCHAR, team VARCHAR)

What position does the player from the Arizona Diamondbacks play?
SELECT position FROM table_name_6 WHERE team = "arizona diamondbacks"
SELECT "position" FROM "table_name_6" WHERE "arizona diamondbacks" = "team"