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 treinador trabalha com Robert Harvey?
 ###Tabelas: CREATE TABLE team_distribution (team_distribution_id AUTO_INCREMENT PRIMARY KEY, Round VARCHAR, Clubs remaining INT, Clubs involved INT, Winners from previous round VARCHAR, New entries this round VARCHAR, Leagues entering at this round VARCHAR) CREATE TABLE emigration_of_jews_and_their_family_members_from_the_former_ussr: (emigration_of_jews_and_their_family_members_from_the_former_ussr:_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Total (000s) INT, Israel INT, Germany INT, Jews (Halakha) in Israel VARCHAR) CREATE TABLE electoral_history (electoral_history_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Seats in House INT, Liberal candidates INT, Seats won INT, Seat Change VARCHAR, Popular vote INT, % of popular vote VARCHAR, Result VARCHAR, Liberal leader VARCHAR) CREATE TABLE highest_percentage_of_pole_positions_in_a_season (highest_percentage_of_pole_positions_in_a_season_id AUTO_INCREMENT PRIMARY KEY, Driver VARCHAR, Season INT, Races INT, Poles INT, Percentage VARCHAR) CREATE TABLE on_ice_officials (on_ice_officials_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Coach VARCHAR, Captain VARCHAR, Alternate (1) VARCHAR, Alternate (2) VARCHAR)  
SELECT Coach FROM on_ice_officials WHERE Captain = robert harvey