Which DOB has Bats of r, and Throws of r, and a Position of rhp, and a First of john?
CREATE TABLE "player_roster" (
  "surname" text,
  "first" text,
  "d_o_b" text,
  "bats" text,
  "throws" text,
  "position" text
);
SELECT "d_o_b" FROM "player_roster" WHERE "bats"='r' AND "throws"='r' AND "position"='rhp' AND "first"='john';