Table: draft_picks_8
Columns: draft
round
pick
player
nationality

Question: What is the lowest draft of player jim farrell, who has a pick greater than 197 and a round of 14?
SQL: SELECT MIN("draft") FROM draft_picks_8 WHERE "pick" > 197 AND "round" = 14 AND "player" = 'jim farrell'

Question: What is the lowest pick of player paul stasiuk from a round greater than 12?
SQL: SELECT MIN("pick") FROM draft_picks_8 WHERE "player" = 'paul stasiuk' AND "round" > 12

Question: What is the total pick number of player curt bennett from canada with a draft before 1976 and a round less than 2?
SQL: SELECT COUNT("pick") FROM draft_picks_8 WHERE "nationality" = 'canada' AND "draft" < 1976 AND "player" = 'curt bennett' AND "round" < 2

Question: What is the average pick of player paul maclean, who had a draft before 1978?
SQL: SELECT AVG("pick") FROM draft_picks_8 WHERE "player" = 'paul maclean' AND "draft" < 1978

Question: What is the average round of player dave pulkkinen, who had a draft after 1969?
SQL: SELECT AVG("round") FROM draft_picks_8 WHERE "player" = 'dave pulkkinen' AND "draft" > 1969