Table: draft_pick_5
Columns: round
pick
player
position
nationality
college_junior_team

Question: What is the average round of the rw position player from the United States?
SQL: SELECT AVG("round") FROM draft_pick_5 WHERE "nationality" = 'united states' AND "position" = 'rw'

Question: What is the college/junior team of player tyler myers, who has a pick less than 44?
SQL: SELECT "college_junior_team" FROM draft_pick_5 WHERE "pick" < 44 AND "player" = 'tyler myers'

Question: What is the nationality of player corey fienhage, who has a pick less than 104?
SQL: SELECT "nationality" FROM draft_pick_5 WHERE "pick" < 104 AND "player" = 'corey fienhage'

Question: What is the sum of the pick of the lw position player?
SQL: SELECT SUM("pick") FROM draft_pick_5 WHERE "position" = 'lw'