user: ### NOW ANSWER:
Question: What team did James Vanderberg belong to when the Completions had a status of Redshirt?
Columns: ['Year', 'Team', 'Attempts', 'Completions', 'Completion %', 'Yards']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['2008', 'Iowa', 'Redshirt', 'Redshirt', 'Redshirt', 'Redshirt']
SQL:

assistant: SELECT "Team" FROM "Table" WHERE "Completions" = 'Redshirt';