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: Quando são as datas de nomeação da equipe de Galway?
 ###Tabelas: CREATE TABLE list_of_princesses_royal (list_of_princesses_royal_id AUTO_INCREMENT PRIMARY KEY, Order INT, Name dates VARCHAR, Princess Royal from (date) to (date) VARCHAR, Parent VARCHAR, Date married VARCHAR, Husband dates VARCHAR) CREATE TABLE guernsey_records (guernsey_records_id AUTO_INCREMENT PRIMARY KEY, Fish VARCHAR, Guernsey Record VARCHAR, Year VARCHAR, Location VARCHAR, British Record VARCHAR) CREATE TABLE broadcast_and_reception (broadcast_and_reception_id AUTO_INCREMENT PRIMARY KEY, Episode VARCHAR, Broadcast date VARCHAR, Run time VARCHAR, Viewers (in millions) VARCHAR, Archive VARCHAR) CREATE TABLE list_of_imperial_vicars_1437-1792 (list_of_imperial_vicars_1437-1792_id AUTO_INCREMENT PRIMARY KEY, Interregnum began VARCHAR, Interregnum ended VARCHAR, Duration VARCHAR, Count Palatine of Saxony VARCHAR, Count Palatine of the Rhine VARCHAR) CREATE TABLE managerial_changes (managerial_changes_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Outgoing manager VARCHAR, Manner of departure VARCHAR, Date of vacancy VARCHAR, Replaced by VARCHAR, Date of appointment VARCHAR, Position VARCHAR)  
SELECT Date of appointment FROM managerial_changes WHERE Team = Galway