CREATE TABLE table_name_18 (player VARCHAR2, pick__number VARCHAR2, nationality VARCHAR2, position VARCHAR2)

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