Table: james_vandenberg_stats
Columns: year
team
attempts
completions
completion
yards

Question: What team did James Vanderberg belong to when the Completions had a status of redshirt?
SQL: SELECT "team" FROM james_vandenberg_stats WHERE "completions" = 'redshirt'

Question: What were the number of completions for James Vanderberg on Iowa when his yards were 45?
SQL: SELECT "completions" FROM james_vandenberg_stats WHERE "team" = 'iowa' AND "yards" = '45'

Question: What was the team Vanderberg belonged to when there was 42 completions?
SQL: SELECT "team" FROM james_vandenberg_stats WHERE "completions" = '42'

Question: What number of attempts were recorded when the completions were 223?
SQL: SELECT "attempts" FROM james_vandenberg_stats WHERE "completions" = '223'

Question: In what year was the number of attempts 888?
SQL: SELECT "year" FROM james_vandenberg_stats WHERE "attempts" = '888'

Question: What was the number of attempts for Vanderberg on Iowa when the recorded yards were 2,249?
SQL: SELECT "attempts" FROM james_vandenberg_stats WHERE "team" = 'iowa' AND "yards" = '2,249'