Table: prem_league_teams_1994
Columns: team
manager
captain
kit_manufacturer
shirt_sponsor

Question: Who was the Kit manufacturer that was has shirts sponsored by Walkers?
SQL: SELECT "kit_manufacturer" FROM prem_league_teams_1994 WHERE "shirt_sponsor" = 'walkers'

Question: Which team is the kit manufacturer Umbro, and the captain Gary Mabbutt?
SQL: SELECT "team" FROM prem_league_teams_1994 WHERE "kit_manufacturer" = 'umbro' AND "captain" = 'gary mabbutt'

Question: Who is the captain for the manufacturer Pony, and the manager Harry Redknapp?
SQL: SELECT "captain" FROM prem_league_teams_1994 WHERE "kit_manufacturer" = 'pony' AND "manager" = 'harry redknapp'

Question: Who is the shirt sponsor for the manufacturer Nike?
SQL: SELECT "shirt_sponsor" FROM prem_league_teams_1994 WHERE "kit_manufacturer" = 'nike'

Question: Which team has the team captain Jon Newsome?
SQL: SELECT "team" FROM prem_league_teams_1994 WHERE "captain" = 'jon newsome'