Table: draft_pick_15
Columns: pick
player
nationality
position
team_from
league_from

Question: What pick # has a team from Rimouski Océanic?
SQL: SELECT AVG("pick") FROM draft_pick_15 WHERE "team_from" = 'rimouski océanic'

Question: Who is the player from Hotchkiss School with a position of d?
SQL: SELECT "player" FROM draft_pick_15 WHERE "position" = 'd' AND "team_from" = 'hotchkiss school'