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 treinador principal do clube de Aveiro?
 ###Tabelas: CREATE TABLE third_and_fourth_tiers (third_and_fourth_tiers_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Club VARCHAR, National League VARCHAR, National Cup VARCHAR, European Cup VARCHAR) CREATE TABLE round_10 (round_10_id AUTO_INCREMENT PRIMARY KEY, Home team VARCHAR, Home team score VARCHAR, Away team VARCHAR, Away team score VARCHAR, Venue VARCHAR, Crowd INT, Date VARCHAR) CREATE TABLE team_summaries (team_summaries_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Head Coach VARCHAR, City VARCHAR, Stadium VARCHAR, 2003–2004 season VARCHAR) CREATE TABLE election_results (election_results_id AUTO_INCREMENT PRIMARY KEY, Election INT, Candidates fielded INT, # of seats won INT, Total votes INT, % of popular vote VARCHAR, Place VARCHAR) CREATE TABLE composition_of_the_9th_seanad (composition_of_the_9th_seanad_id AUTO_INCREMENT PRIMARY KEY, Administrative Panel INT, Agricultural Panel INT, Cultural and Educational Panel INT, Industrial and Commercial Panel INT, Labour Panel INT, National University of Ireland INT, University of Dublin INT, Nominated by the Taoiseach INT, Total INT)  
SELECT Head Coach FROM team_summaries WHERE City = aveiro