user: ### NOW ANSWER:
Question: What was the overall draft pick for the player selected for the Tight end position?
Columns: ['Round', 'Overall', 'Player', 'Position', 'College']
Types: ['real', 'real', 'text', 'text', 'text']
Sample row: [1.0, 13.0, 'Ty Warren', 'Defensive tackle', 'Texas A&M']
SQL:

assistant: SELECT "Overall" FROM "Table" WHERE "Position" = 'Tight end';