CREATE TABLE table_50832 ("Year" CLOB, "Team" CLOB, "Attempts" CLOB, "Completions" CLOB, "Completion %" CLOB, "Yards" CLOB)

What team did James Vanderberg belong to when the Completions had a status of redshirt?
SELECT "Team" FROM table_50832 WHERE "Completions" = 'redshirt'
SELECT "Team" FROM "table_50832" WHERE "Completions" = 'redshirt'