Table: rangers_1988_89
Columns: round
player
position
nationality
college_junior_club_team_league

Question: What player has a round larger than 6 with a D position.
SQL: SELECT "player" FROM rangers_1988_89 WHERE "round" > 6 AND "position" = 'd'

Question: What league is from the United States and a round smaller than 12.
SQL: SELECT "college_junior_club_team_league" FROM rangers_1988_89 WHERE "nationality" = 'united states' AND "round" < 12

Question: What league has a 10 for round with Paul Cain?
SQL: SELECT "college_junior_club_team_league" FROM rangers_1988_89 WHERE "round" = 10 AND "player" = 'paul cain'

Question: What league has a D position, a round smaller than 11 and is with Dennis Vial?
SQL: SELECT "college_junior_club_team_league" FROM rangers_1988_89 WHERE "position" = 'd' AND "round" < 11 AND "player" = 'dennis vial'