Table: premier_league_teams_2
Columns: team
manager_1
captain
kit_manufacturer
shirt_sponsor

Question: Who was the shirt sponsor for the Blackburn Rovers?
SQL: SELECT "shirt_sponsor" FROM premier_league_teams_2 WHERE "team" = 'blackburn rovers'

Question: Who was the team captain of the Bolton Wanderers?
SQL: SELECT "captain" FROM premier_league_teams_2 WHERE "team" = 'bolton wanderers'

Question: For which team did Adidas manufacture kits and TDK sponsor shirts?
SQL: SELECT "team" FROM premier_league_teams_2 WHERE "kit_manufacturer" = 'adidas' AND "shirt_sponsor" = 'tdk'

Question: On which team was Robbie Earle the captain?
SQL: SELECT "team" FROM premier_league_teams_2 WHERE "captain" = 'robbie earle'

Question: Who was the manager for the team with captain Neil Redfearn?
SQL: SELECT "manager_1" FROM premier_league_teams_2 WHERE "captain" = 'neil redfearn'

Question: Who was the team captain for Crystal Palace?
SQL: SELECT "captain" FROM premier_league_teams_2 WHERE "team" = 'crystal palace'