Table: player_draft
Columns: round
pick
player
position
college

Question: WHo is the Player got a Pick # smaller than 61, and a College of texas?
SQL: SELECT "player" FROM player_draft WHERE "pick" < 61 AND "college" = 'texas'

Question: Name the College which has a Round smaller than 3, and a Pick # larger than 4, and a Position of wide receiver?
SQL: SELECT "college" FROM player_draft WHERE "round" < 3 AND "pick" > 4 AND "position" = 'wide receiver'

Question: Which the highest Round has a Player of mike williams, and a Pick # larger than 4?
SQL: SELECT MAX("round") FROM player_draft WHERE "player" = 'mike williams' AND "pick" > 4

Question: Name the average Pick # of mike williams?
SQL: SELECT AVG("pick") FROM player_draft WHERE "player" = 'mike williams'