Table: mlb_draft_1995
Columns: pick
player
team
position
hometown_school

Question: WHAT IS THE TEAM WITH DAVE COGGIN?
SQL: SELECT "team" FROM mlb_draft_1995 WHERE "player" = 'dave coggin'

Question: WHAT IS THE TEAM WITH AN OF POSITION AND PICK OF 24?
SQL: SELECT "team" FROM mlb_draft_1995 WHERE "position" = 'of' AND "pick" = 24

Question: WHAT IS THE POSITION WITH BOSTON RED SOX FOR COREY JENKINS?
SQL: SELECT "position" FROM mlb_draft_1995 WHERE "team" = 'boston red sox' AND "player" = 'corey jenkins'

Question: WHAT PLAYER HAS UPLAND HIGH SCHOOL?
SQL: SELECT "player" FROM mlb_draft_1995 WHERE "hometown_school" = 'upland high school'

Question: WHAT PLAYER HAS THE OAKLAND ATHLETICS?
SQL: SELECT "player" FROM mlb_draft_1995 WHERE "team" = 'oakland athletics'

Question: WHAT TEAM HAS A PICK LARGER THAN 29?
SQL: SELECT "team" FROM mlb_draft_1995 WHERE "pick" > 29