CREATE TABLE table_name_14 (position VARCHAR2, bats VARCHAR2, surname VARCHAR2)

Which position has L bats and Anderson as a surname?
SELECT position FROM table_name_14 WHERE bats = "l" AND surname = "anderson"
SELECT "position" FROM "table_name_14" WHERE "anderson" = "surname" AND "bats" = "l"