Table: draft_history_38
Columns: round
pick
overall
name
position
college

Question: Which is the lowest round to have a pick of 12 and position of linebacker?
SQL: SELECT MIN("round") FROM draft_history_38 WHERE "pick" = 12 AND "position" = 'linebacker'

Question: Which player was picked in round 15 with a pick smaller than 13?
SQL: SELECT "name" FROM draft_history_38 WHERE "pick" < 13 AND "round" = 15

Question: How many picks were from Lamar College?
SQL: SELECT COUNT("pick") FROM draft_history_38 WHERE "college" = 'lamar'

Question: How many overall values have a college of Notre Dame and rounds over 2?
SQL: SELECT COUNT("overall") FROM draft_history_38 WHERE "college" = 'notre dame' AND "round" > 2