Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Qual gerente tem Sol Campbell como capitão?
 ###Tabelas: CREATE TABLE germanic_origins (germanic_origins_id AUTO_INCREMENT PRIMARY KEY, Proto-Germanic VARCHAR, West Germanic VARCHAR, Old English VARCHAR, German VARCHAR, Dutch VARCHAR) CREATE TABLE mixed_doubles:_7_5_titles_2_runner-ups (mixed_doubles:_7_5_titles_2_runner-ups_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Year INT, Championship VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents in the final VARCHAR, Score in the final VARCHAR) CREATE TABLE affiliate_members (affiliate_members_id AUTO_INCREMENT PRIMARY KEY, Institution VARCHAR, Location VARCHAR, Founded INT, Type VARCHAR, Enrollment INT, Nickname VARCHAR, Current Conference VARCHAR, Pac-12 Sports VARCHAR) CREATE TABLE personnel_and_kits (personnel_and_kits_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Manager VARCHAR, Captain VARCHAR, Kit maker VARCHAR, Shirt sponsor VARCHAR) CREATE TABLE most_played_songs (most_played_songs_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Song title VARCHAR, Composer(s) VARCHAR, Performer(s) VARCHAR, Year INT)  
SELECT Manager FROM personnel_and_kits WHERE Captain = sol campbell