Table: claxton_shield_players_3
Columns: surname
first
d_o_b
uni
bats
throws
position

Question: What is Marc's Surname?
SQL: SELECT "surname" FROM claxton_shield_players_3 WHERE "first" = 'marc'

Question: What is the highest uni# of the person with the first name Todd?
SQL: SELECT MAX("uni") FROM claxton_shield_players_3 WHERE "first" = 'todd'

Question: Which position does #14 play?
SQL: SELECT "position" FROM claxton_shield_players_3 WHERE "uni" = 14

Question: Which does the lhp player with the first name lachlan bat?
SQL: SELECT "bats" FROM claxton_shield_players_3 WHERE "position" = 'lhp' AND "first" = 'lachlan'