Table: jhn_hndrsn_2002_jax
Columns: round
pick
overall
name
position
college

Question: Akin Ayodele drafted before round 7 plays what position?
SQL: SELECT "position" FROM jhn_hndrsn_2002_jax WHERE "round" < 7 AND "name" = 'akin ayodele'

Question: What is the total overall for the pick that went before round 4, who went to Tennessee for college, and was picked at a number bigger than 9?
SQL: SELECT SUM("overall") FROM jhn_hndrsn_2002_jax WHERE "round" < 4 AND "college" = 'tennessee' AND "pick" > 9

Question: What is the pick number average for the player who was drafted before round 7, and went to college at Tennessee?
SQL: SELECT AVG("pick") FROM jhn_hndrsn_2002_jax WHERE "round" < 7 AND "college" = 'tennessee'