Table: dodgers_players_1966
Columns: round
name
position
school
signed

Question: What is the round for bob randall?
SQL: SELECT AVG("round") FROM dodgers_players_1966 WHERE "name" = 'bob randall'

Question: what is the position when signed is yes, round is less than 24 and name is charlie hough?
SQL: SELECT "position" FROM dodgers_players_1966 WHERE "signed" = 'yes' AND "round" < 24 AND "name" = 'charlie hough'

Question: what is the school when signed is no and round is 50?
SQL: SELECT "school" FROM dodgers_players_1966 WHERE "signed" = 'no' AND "round" = 50

Question: what is the school for round 8?
SQL: SELECT "school" FROM dodgers_players_1966 WHERE "round" = 8

Question: what is the position for robert johnson?
SQL: SELECT "position" FROM dodgers_players_1966 WHERE "name" = 'robert johnson'

Question: Was position ss from carson city high school signed?
SQL: SELECT "signed" FROM dodgers_players_1966 WHERE "position" = 'ss' AND "school" = 'carson city high school'