Table: draft_picks_1983_7
Columns: round
pick
player
position
college

Question: What is the lowest Pick #, when College is "Jackson State"?
SQL: SELECT MIN("pick") FROM draft_picks_1983_7 WHERE "college" = 'jackson state'

Question: What is Pick #, when Round is "10"?
SQL: SELECT "pick" FROM draft_picks_1983_7 WHERE "round" = 10

Question: What is Player, when Round is greater than 8, when Pick # is greater than 234, and when College is "Louisville"?
SQL: SELECT "player" FROM draft_picks_1983_7 WHERE "round" > 8 AND "pick" > 234 AND "college" = 'louisville'

Question: What is the average Round, when Player is "Gurnest Brown", and when Pick # is greater than 180?
SQL: SELECT AVG("round") FROM draft_picks_1983_7 WHERE "player" = 'gurnest brown' AND "pick" > 180

Question: What is the lowest Pick #, when College is "Louisville", and when Round is less than 10?
SQL: SELECT MIN("pick") FROM draft_picks_1983_7 WHERE "college" = 'louisville' AND "round" < 10