Table: premier_league_teams
Columns: team
manager
captain
kit_manufacturer
shirt_sponsor

Question: Which Kit manufacturer sponsers Arsenal?
SQL: SELECT "kit_manufacturer" FROM premier_league_teams WHERE "team" = 'arsenal'

Question: Which captain is managed by gianluca vialli?
SQL: SELECT "captain" FROM premier_league_teams WHERE "manager" = 'gianluca vialli'

Question: Which Kit Manufacturer supports team Everton?
SQL: SELECT "kit_manufacturer" FROM premier_league_teams WHERE "team" = 'everton'

Question: Which team does David O'leary manage?
SQL: SELECT "team" FROM premier_league_teams WHERE "manager" = 'david o''leary'

Question: Which shirt sponser has Nike as a kit manufacturer?
SQL: SELECT "shirt_sponsor" FROM premier_league_teams WHERE "kit_manufacturer" = 'nike'