Table: flames_draft_3
Columns: round
pick
player
nationality
college_junior_club_team

Question: What was the College/junior/club team of the player with the united states nationality?
SQL: SELECT "college_junior_club_team" FROM flames_draft_3 WHERE "nationality" = 'united states'

Question: What was the lowest pick number for a united states player picked before round 7?
SQL: SELECT MIN("pick") FROM flames_draft_3 WHERE "round" > 7 AND "nationality" = 'united states'