A que equipa pertencia o James Vanderberg quando os Completions tinham o estatuto de camisa vermelha?
CREATE TABLE table_name_21 (team VARCHAR, completions VARCHAR)
SELECT team FROM table_name_21 WHERE completions = "redshirt"