Table: nhl_draft_1994_2
Columns: pick
player
position
nationality
nhl_team
college_junior_club_team

Question: What college/junior/club teams do the players from the St. Louis Blues come from?
SQL: SELECT "college_junior_club_team" FROM nhl_draft_1994_2 WHERE "nhl_team" = 'St. Louis Blues'

Question: What teams do the players from TPS (Finland) play for?
SQL: SELECT "nhl_team" FROM nhl_draft_1994_2 WHERE "college_junior_club_team" = 'TPS (Finland)'

Question: What high school team did Doug Nolan play for?
SQL: SELECT "college_junior_club_team" FROM nhl_draft_1994_2 WHERE "player" = 'Doug Nolan'

Question: What club team is Per Gustafsson play for?
SQL: SELECT "college_junior_club_team" FROM nhl_draft_1994_2 WHERE "player" = 'Per Gustafsson'

Question: What is the nationality of Shayne Wright?
SQL: SELECT "nationality" FROM nhl_draft_1994_2 WHERE "player" = 'Shayne Wright'