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: Nomeie o número de capitães para o Barcelona.
 ###Tabelas: CREATE TABLE undergraduate_chapters_associate_chapters__&__colonies (undergraduate_chapters_associate_chapters__&__colonies_id AUTO_INCREMENT PRIMARY KEY, Greek Designation VARCHAR, Collegiate Institution VARCHAR, Charter Date VARCHAR, Status VARCHAR, City VARCHAR, U.S. State/District VARCHAR) CREATE TABLE allegations_of_children_born_to_alleged_polygamous_wives (allegations_of_children_born_to_alleged_polygamous_wives_id AUTO_INCREMENT PRIMARY KEY, Child VARCHAR, Date of birth VARCHAR, Mother VARCHAR, Father VARCHAR, DNA testing status VARCHAR) CREATE TABLE best_figures_in_a_match (best_figures_in_a_match_id AUTO_INCREMENT PRIMARY KEY, Rank VARCHAR, Bowling VARCHAR, Player VARCHAR, Opponent VARCHAR, Venue VARCHAR, Season VARCHAR) CREATE TABLE personnel_and_sponsorship (personnel_and_sponsorship_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Chairman VARCHAR, Head Coach VARCHAR, Captain VARCHAR, Kitmaker VARCHAR, Shirt sponsor VARCHAR) CREATE TABLE headstamps_and_colour-coding (headstamps_and_colour-coding_id AUTO_INCREMENT PRIMARY KEY, Headstamp ID VARCHAR, Primer Annulus Color VARCHAR, Bullet Tip Color VARCHAR, Other Features VARCHAR, Functional Type VARCHAR)  
SELECT COUNT Captain FROM personnel_and_sponsorship WHERE Team = Barcelona