Table: player_draft_4
Columns: round
pick
player
nationality
college

Question: How many picks on average did Jay Bruchak have before round 6?
SQL: SELECT AVG("pick") FROM player_draft_4 WHERE "player" = 'jay bruchak' AND "round" < 6

Question: How many rounds did Pierre Bland have a pick larger than 148?
SQL: SELECT COUNT("round") FROM player_draft_4 WHERE "pick" > 148 AND "player" = 'pierre bland'

Question: What was the earliest round that Purdue had a pick larger than 10?
SQL: SELECT MIN("round") FROM player_draft_4 WHERE "college" = 'purdue' AND "pick" > 10

Question: How many picks did Jay Bruchak have?
SQL: SELECT COUNT("pick") FROM player_draft_4 WHERE "player" = 'jay bruchak'