Which Surname has Bats of r, and a Position of p, and a DOB of 20 may 1989?
CREATE TABLE "player_roster" (
  "surname" text,
  "first" text,
  "d_o_b" text,
  "bats" text,
  "throws" text,
  "position" text
);
SELECT "surname" FROM "player_roster" WHERE "bats"='r' AND "position"='p' AND "d_o_b"='20 may 1989';