CREATE TABLE table_name_90 (bats VARCHAR, surname VARCHAR, first VARCHAR, throws VARCHAR)

Which Bats have a First of josh, and Throws of r, and a Surname of cakebread?
SELECT bats FROM table_name_90 WHERE first = "josh" AND throws = "r" AND surname = "cakebread"
SELECT "bats" FROM "table_name_90" WHERE "cakebread" = "surname" AND "first" = "josh" AND "r" = "throws"