Table: draft_player
Columns: round
pick
player
position
college
tenure_w_steelers

Question: What is the average round for draft pick #49 from Notre Dame?
SQL: SELECT AVG("round") FROM draft_player WHERE "college" = 'notre dame' AND "pick" = '49'

Question: What college is draft pick #327 from?
SQL: SELECT "college" FROM draft_player WHERE "pick" = '327'

Question: What college is pick number 268 from?
SQL: SELECT "college" FROM draft_player WHERE "pick" = '268'

Question: What round pick was pick number 101 who plays defensive back?
SQL: SELECT "round" FROM draft_player WHERE "position" = 'defensive back' AND "pick" = '101'

Question: What pick number was from the college of maryland and was picked in a round larger than 7?
SQL: SELECT "pick" FROM draft_player WHERE "round" > 7 AND "college" = 'maryland'