Which Bats have a First of josh, and Throws of r, and a Surname of cakebread?
CREATE TABLE "player_roster" (
  "surname" text,
  "first" text,
  "d_o_b" text,
  "bats" text,
  "throws" text,
  "position" text
);
SELECT "bats" FROM "player_roster" WHERE "first"='josh' AND "throws"='r' AND "surname"='cakebread';