Table: draft_history_8
Columns: round
pick
overall
name
position
college

Question: What was the Pick Number when the position was wide receiver, the college was Southern Miss with an overall less than 186?
SQL: SELECT AVG("pick") FROM draft_history_8 WHERE "position" = 'wide receiver' AND "college" = 'southern miss' AND "overall" < 186

Question: Let's say position was linebacker with a pick number less than 5, what was the highest round?
SQL: SELECT MAX("round") FROM draft_history_8 WHERE "position" = 'linebacker' AND "pick" > 5