Table: premier_league_teams
Columns: team
manager
captain
kit_maker
shirt_sponsor

Question: Which manager has Sol Campbell as captain?
SQL: SELECT "manager" FROM premier_league_teams WHERE "captain" = 'sol campbell'

Question: What team does Carlsberg sponsor?
SQL: SELECT "team" FROM premier_league_teams WHERE "shirt_sponsor" = 'carlsberg'

Question: Who sponsors Middlesbrough?
SQL: SELECT "shirt_sponsor" FROM premier_league_teams WHERE "team" = 'middlesbrough'

Question: Which sponsor has Mark Hughes as manager?
SQL: SELECT "shirt_sponsor" FROM premier_league_teams WHERE "manager" = 'mark hughes'

Question: Which kit maker does Aston Villa use?
SQL: SELECT "kit_maker" FROM premier_league_teams WHERE "team" = 'aston villa'

Question: Who captains Portsmouth?
SQL: SELECT "captain" FROM premier_league_teams WHERE "team" = 'portsmouth'