Table: draft_pick_28
Columns: pick
player
team
position
school

Question: What is the School with a Pick that is 24?
SQL: SELECT "school" FROM draft_pick_28 WHERE "pick" = 24

Question: What is the Team with a Player that is david cooper?
SQL: SELECT "team" FROM draft_pick_28 WHERE "player" = 'david cooper'