Table: draft_picks_2000
Columns: round
overall
player
position
college

Question: Name the average round where Dave Stachelski was picked smaller than 187.
SQL: SELECT AVG("round") FROM draft_picks_2000 WHERE "overall" < 187 AND "player" = 'dave stachelski'

Question: Which position did David Nugent play with an overall small than 187?
SQL: SELECT "position" FROM draft_picks_2000 WHERE "overall" > 187 AND "player" = 'david nugent'

Question: Name the college that has an overall larger than 187 and a round smaller than 7 for the defensive end position.
SQL: SELECT "college" FROM draft_picks_2000 WHERE "overall" > 187 AND "round" < 7 AND "position" = 'defensive end'