CREATE TABLE table_36835 ("Surname" CLOB, "First" CLOB, "D.O.B." CLOB, "Bats" CLOB, "Throws" CLOB, "Position" CLOB)

Which First has Bats of r, and Throws of l, and a DOB of 12 october 1977?
SELECT "First" FROM table_36835 WHERE "Bats" = 'r' AND "Throws" = 'l' AND "D.O.B." = '12 october 1977'
SELECT "First" FROM "table_36835" WHERE "Bats" = 'r' AND "D.O.B." = '12 october 1977' AND "Throws" = 'l'