Table: t_1965_afl_draft_2
Columns: pick
team
player
position
college

Question: who is the player from arizona state?
SQL: SELECT "player" FROM t_1965_afl_draft_2 WHERE "college" = 'arizona state'

Question: what is the position of the player from florida?
SQL: SELECT "position" FROM t_1965_afl_draft_2 WHERE "college" = 'florida'

Question: what is the highest pick for the position tight end?
SQL: SELECT MAX("pick") FROM t_1965_afl_draft_2 WHERE "position" = 'tight end'