user: ### NOW ANSWER:
Question: Which manager has Sol Campbell as captain?
Columns: ['Team', 'Manager', 'Captain', 'Kit maker', 'Shirt sponsor']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Arsenal', 'Arsène Wenger', 'William Gallas', 'Nike', 'Emirates']
SQL:

assistant: SELECT "Manager" FROM "Table" WHERE "Captain" = 'Sol Campbell';