CREATE TABLE table_name_18 (player VARCHAR2, position VARCHAR2)

Which Player has a Position of forward?
SELECT player FROM table_name_18 WHERE position = "forward"
SELECT "player" FROM "table_name_18" WHERE "forward" = "position"