Table: claxton_shield_players_6
Columns: surname
first
d_o_b
bats
throws
position

Question: When was Lachlan Dale born?
SQL: SELECT "d_o_b" FROM claxton_shield_players_6 WHERE "surname" = 'dale' AND "first" = 'lachlan'

Question: Which batter played P and was born 18 April 1984?
SQL: SELECT "bats" FROM claxton_shield_players_6 WHERE "position" = 'p' AND "d_o_b" = '18 april 1984'

Question: Which Surname has Bats of r, and a Position of p, and a DOB of 20 may 1989?
SQL: SELECT "surname" FROM claxton_shield_players_6 WHERE "bats" = 'r' AND "position" = 'p' AND "d_o_b" = '20 may 1989'

Question: Which Position has Throws of r, and a DOB of 12 february 1983?
SQL: SELECT "position" FROM claxton_shield_players_6 WHERE "throws" = 'r' AND "d_o_b" = '12 february 1983'

Question: How many throws did Needle have?
SQL: SELECT "throws" FROM claxton_shield_players_6 WHERE "surname" = 'needle'

Question: Which DOB has Bats of s, and a Position of inf?
SQL: SELECT "d_o_b" FROM claxton_shield_players_6 WHERE "bats" = 's' AND "position" = 'inf'