Table: draft_picks_1973_2
Columns: pick
player
position
nationality
nhl_team
college_junior_club_team

Question: What player was drafted to the Detroit Red Wings?
SQL: SELECT "player" FROM draft_picks_1973_2 WHERE "nhl_team" = 'Detroit Red Wings'

Question: Who did Dan Follet play for before the draft?
SQL: SELECT "college_junior_club_team" FROM draft_picks_1973_2 WHERE "player" = 'Dan Follet'

Question: How many teams have a player named Denis Andersen?
SQL: SELECT COUNT("nhl_team") FROM draft_picks_1973_2 WHERE "player" = 'Denis Andersen'

Question: Which College did the Buffalo Sabres' pick play for?
SQL: SELECT "college_junior_club_team" FROM draft_picks_1973_2 WHERE "nhl_team" = 'Buffalo Sabres'