Table: draft_pick_40
Columns: pick
player
team
position
hometown_school

Question: What was the average pick made by the Texas Rangers?
SQL: SELECT AVG("pick") FROM draft_pick_40 WHERE "team" = 'texas rangers'

Question: What was the home town of Bob Geren, picked by the San Diego Padres?
SQL: SELECT "hometown_school" FROM draft_pick_40 WHERE "team" = 'san diego padres' AND "player" = 'bob geren'

Question: What was the position of Jon Perlman?
SQL: SELECT "position" FROM draft_pick_40 WHERE "player" = 'jon perlman'