CREATE TABLE table_name_2 (player VARCHAR2, position VARCHAR2)

What players have a position of F?
SELECT player FROM table_name_2 WHERE position = "f"
SELECT "player" FROM "table_name_2" WHERE "f" = "position"