Table schema:
CREATE TABLE table_name_18 (player VARCHAR, pick__number VARCHAR, nationality VARCHAR, position VARCHAR)

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