user: Question: How many picks played Tight End?
Columns: ['Pick #', 'NFL Team', 'Player', 'Position', 'College']
Types: ['real', 'text', 'text', 'text', 'text']
Sample row: [18.0, 'Green Bay Packers', 'Tony Bennett', 'Linebacker', 'Mississippi']
SQL:

assistant: SELECT COUNT("Pick #") FROM "Table" WHERE "Position" = 'Tight End';