Table: draft_picks_1996_2
Columns: pick
player
position
nationality
nhl_team
college_junior_club_team

Question: who is the person that plays left wing and is from canada that plays on the st. louis blues
SQL: SELECT "player" FROM draft_picks_1996_2 WHERE "position" = 'Left Wing' AND "nationality" = 'Canada' AND "nhl_team" = 'St. Louis Blues'

Question: what is the overall number of chosen ideas where the person is scott parker
SQL: SELECT COUNT("pick") FROM draft_picks_1996_2 WHERE "player" = 'Scott Parker'

Question: what is the number of the chosen club where the hc dukla trenčín (slovakia) is from
SQL: SELECT COUNT("pick") FROM draft_picks_1996_2 WHERE "college_junior_club_team" = 'HC Dukla Trenčín (Slovakia)'