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: quem é o capitão onde o treinador é geoff miles
 ###Tabelas: CREATE TABLE gold_plated_proof_silver_dollars (gold_plated_proof_silver_dollars_id AUTO_INCREMENT PRIMARY KEY, Year INT, Theme VARCHAR, Artist VARCHAR, Mintage VARCHAR, Issue Price VARCHAR) CREATE TABLE honour_board (honour_board_id AUTO_INCREMENT PRIMARY KEY, Season INT, Position INT, Win/Loss VARCHAR, Coach VARCHAR, Captain VARCHAR, Dudley Tuckey Medal VARCHAR, Leading goalkicker VARCHAR) CREATE TABLE club_world_cup_finalists_by_nation (club_world_cup_finalists_by_nation_id AUTO_INCREMENT PRIMARY KEY, Nation VARCHAR, Finalists INT, Winners INT, Runners-up INT, % won INT, Years won VARCHAR) CREATE TABLE by_population_density (by_population_density_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Province VARCHAR, Population INT, Area INT, Density INT) CREATE TABLE 2011_regular_season_football_standings (2011_regular_season_football_standings_id AUTO_INCREMENT PRIMARY KEY, School VARCHAR, Team VARCHAR, Division Record VARCHAR, Overall Record VARCHAR, Season Outcome VARCHAR)  
SELECT Captain FROM honour_board WHERE Coach = Geoff Miles