CREATE TABLE table_name_9 (bats VARCHAR2, position VARCHAR2, first VARCHAR2)

Which does the lhp player with the first name lachlan bat?
SELECT bats FROM table_name_9 WHERE position = "lhp" AND first = "lachlan"
SELECT "bats" FROM "table_name_9" WHERE "first" = "lachlan" AND "lhp" = "position"