Table: draft_picks_1989_2
Columns: pick
player
position
nationality
nhl_team
college_junior_club_team

Question: What player attended avon old farms (ushs-ct)?
SQL: SELECT "player" FROM draft_picks_1989_2 WHERE "college_junior_club_team" = 'Avon Old Farms (USHS-CT)'

Question: What pick number was marc deschamps?
SQL: SELECT "pick" FROM draft_picks_1989_2 WHERE "player" = 'Marc Deschamps'

Question: What nationality is keith carney?
SQL: SELECT "nationality" FROM draft_picks_1989_2 WHERE "player" = 'Keith Carney'

Question: What position did the #94 pick play?
SQL: SELECT "position" FROM draft_picks_1989_2 WHERE "pick" = 94