Table: claxton_shield_players_7
Columns: surname
first
d_o_b
bats
throws
position

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

Question: Which DOB has Throws of r, and a Position of c, and a First of torey?
SQL: SELECT "d_o_b" FROM claxton_shield_players_7 WHERE "throws" = 'r' AND "position" = 'c' AND "first" = 'torey'

Question: Which DOB has a Surname of cresswell?
SQL: SELECT "d_o_b" FROM claxton_shield_players_7 WHERE "surname" = 'cresswell'

Question: Which DOB has Bats of r, and Throws of r, and a Position of rhp, and a First of john?
SQL: SELECT "d_o_b" FROM claxton_shield_players_7 WHERE "bats" = 'r' AND "throws" = 'r' AND "position" = 'rhp' AND "first" = 'john'

Question: Which Position did Ruzic play?
SQL: SELECT "position" FROM claxton_shield_players_7 WHERE "surname" = 'ruzic'

Question: How many throws did Torey have?
SQL: SELECT "throws" FROM claxton_shield_players_7 WHERE "first" = 'torey'