user: ### NOW ANSWER:
Question: Which Long has Redshirt for its Avg/G?
Columns: ['Season', 'GP–GS', 'Yards', 'Long', 'Avg/G']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['2006', 'Redshirt', 'Redshirt', 'Redshirt', 'Redshirt']
SQL:

assistant: SELECT "Long" FROM "Table" WHERE "Avg/G" = 'Redshirt';