Table: canadiens_drafts_2
Columns: round
player
position
nationality
college_junior_club_team_league

Question: What is Player, when College/Junior/Club Team (League) is "Val d'Or Foreurs ( QMJHL )"?
SQL: SELECT "player" FROM canadiens_drafts_2 WHERE "college_junior_club_team_league" = 'val d''or foreurs ( qmjhl )'

Question: What is the Position, when Player is "Magnus Nygren"?
SQL: SELECT "position" FROM canadiens_drafts_2 WHERE "player" = 'magnus nygren'

Question: What is Position, when Round is less than 5, when Nationality is "Canada", and when College/Junior/Club Team (League) is "Saint John Sea Dogs ( QMJHL )"?
SQL: SELECT "position" FROM canadiens_drafts_2 WHERE "round" < 5 AND "nationality" = 'canada' AND "college_junior_club_team_league" = 'saint john sea dogs ( qmjhl )'

Question: What is College/Junior/Club Team (League), when Position is "Defence", when Nationality is "Canada", when Round is less than 5, and when Player is "Josiah Didier"?
SQL: SELECT "college_junior_club_team_league" FROM canadiens_drafts_2 WHERE "position" = 'defence' AND "nationality" = 'canada' AND "round" < 5 AND "player" = 'josiah didier'