Table: draft_picks_34
Columns: pick
player
position
nationality
nhl_team
college_junior_club_team

Question: What team draft a player from Canada that was picked #43 and plays right wing?
SQL: SELECT "nhl_team" FROM draft_picks_34 WHERE "nationality" = 'canada' AND "position" = 'right wing' AND "pick" = '43'

Question: What nationality is Gerry Methe?
SQL: SELECT "nationality" FROM draft_picks_34 WHERE "player" = 'gerry methe'

Question: What which player from Canada was picked #49 and plays left wing?
SQL: SELECT "player" FROM draft_picks_34 WHERE "nationality" = 'canada' AND "position" = 'left wing' AND "pick" = '49'

Question: What Nationality is Dave Hynes?
SQL: SELECT "nationality" FROM draft_picks_34 WHERE "player" = 'dave hynes'

Question: The Estevan Bruins (WCHL) are affiliated with what NHL team?
SQL: SELECT "nhl_team" FROM draft_picks_34 WHERE "college_junior_club_team" = 'estevan bruins (wchl)'