Table: draft_picks_30
Columns: round
overall
player
nationality
club_team

Question: What is the name of the player picked before round 2?
SQL: SELECT "player" FROM draft_picks_30 WHERE "round" < 2

Question: What is the name of the player with an overall less than 209 for the Victoriaville tigres (qmjhl), and a Round of 1?
SQL: SELECT "player" FROM draft_picks_30 WHERE "overall" < 209 AND "club_team" = 'victoriaville tigres (qmjhl)' AND "round" = 1

Question: What is the name of the player with an Overall larger than 227?
SQL: SELECT "player" FROM draft_picks_30 WHERE "overall" > 227

Question: What is the highest overall for a round larger than 8 for pavol demitra?
SQL: SELECT MAX("overall") FROM draft_picks_30 WHERE "round" > 8 AND "player" = 'pavol demitra'