Table: draft_picks_8
Columns: pick
player
nationality
position
league_from

Question: What pick was Scott Glennie from the Western hockey league
SQL: SELECT "pick" FROM draft_picks_8 WHERE "league_from" = 'western hockey league' AND "player" = 'scott glennie'

Question: What player from the United States played in the western collegiate hockey association?
SQL: SELECT "player" FROM draft_picks_8 WHERE "nationality" = 'united states' AND "league_from" = 'western collegiate hockey association'