Table: draft_picks_48
Columns: pick
player
position
nationality
nhl_team
college_junior_club_team

Question: What position does Barry Richter play?
SQL: SELECT "position" FROM draft_picks_48 WHERE "player" = 'barry richter'

Question: What nationality is Mark Hirth from Michigan State University (NCAA)?
SQL: SELECT "nationality" FROM draft_picks_48 WHERE "college_junior_club_team" = 'michigan state university (ncaa)' AND "player" = 'mark hirth'

Question: What NHL team does Rob White play on?
SQL: SELECT "nhl_team" FROM draft_picks_48 WHERE "player" = 'rob white'

Question: What is the pick number for position of D from the University of Maine (NCAA)?
SQL: SELECT "pick" FROM draft_picks_48 WHERE "position" = 'd' AND "college_junior_club_team" = 'university of maine (ncaa)'

Question: What college/junior/club team is a left wing from Canada?
SQL: SELECT "college_junior_club_team" FROM draft_picks_48 WHERE "position" = 'left wing' AND "nationality" = 'canada'