CREATE TABLE table_name_29 (manager VARCHAR(255), captain VARCHAR(255))
Which manager has Sol Campbell as captain?
    
SQL: SELECT manager FROM table_name_29 WHERE captain = "sol campbell"