CREATE TABLE table_34364 ("Surname" CLOB, "First" CLOB, "D.O.B." CLOB, "Uni#" FLOAT, "Bats" CLOB, "Throws" CLOB, "Position" CLOB)

Which does the lhp player with the first name lachlan bat?
SELECT "Bats" FROM table_34364 WHERE "Position" = 'lhp' AND "First" = 'lachlan'
SELECT "Bats" FROM "table_34364" WHERE "First" = 'lachlan' AND "Position" = 'lhp'