Table: mike_sherrard
Columns: round
pick
name
position
school

Question: Who is the person from round 8?
SQL: SELECT "name" FROM mike_sherrard WHERE "round" = 8

Question: What is the round for Arizona with a pick over 100?
SQL: SELECT AVG("round") FROM mike_sherrard WHERE "school" = 'arizona' AND "pick" > 100

Question: What pick had a wide receiver named johnny holloway?
SQL: SELECT "pick" FROM mike_sherrard WHERE "position" = 'wide receiver' AND "name" = 'johnny holloway'