Table: player_stats_8
Columns: round
player
position
nationality
college_junior_club_team_league

Question: What is the position of the player from round 2 from Sweden?
SQL: SELECT "position" FROM player_stats_8 WHERE "round" = 2 AND "nationality" = 'sweden'

Question: What is the highest round of Ian Cole, who played position d from the United States?
SQL: SELECT MAX("round") FROM player_stats_8 WHERE "position" = 'd' AND "nationality" = 'united states' AND "player" = 'ian cole'

Question: Who is the player from Denmark who plays position c?
SQL: SELECT "player" FROM player_stats_8 WHERE "position" = 'c' AND "nationality" = 'denmark'

Question: Which college/junior/club team (league) did Brett Sonne play in?
SQL: SELECT "college_junior_club_team_league" FROM player_stats_8 WHERE "player" = 'brett sonne'