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 é a média de Chesterfield Spires?
 ###Tabelas: CREATE TABLE past_composition_of_the_executive_board (past_composition_of_the_executive_board_id AUTO_INCREMENT PRIMARY KEY, President VARCHAR, Treasurer VARCHAR, Secretary VARCHAR, Social AO VARCHAR, Academic AO VARCHAR, Internal CO VARCHAR, External CO VARCHAR) CREATE TABLE winners (winners_id AUTO_INCREMENT PRIMARY KEY, Event VARCHAR, Date VARCHAR, Location VARCHAR, Winning skip VARCHAR, Runner-up skip VARCHAR) CREATE TABLE season_2006 (season_2006_id AUTO_INCREMENT PRIMARY KEY, Position INT, Club VARCHAR, Played INT, H-Win INT, H-Draw INT, A-Win INT, A-Draw INT, Lost INT, Def. INT, Pts For INT, Pts Agst INT, Pair INT, Long INT, Points INT, Average VARCHAR) CREATE TABLE classification_of_needs (classification_of_needs_id AUTO_INCREMENT PRIMARY KEY, Need VARCHAR, Being (qualities) VARCHAR, Having (things) VARCHAR, Doing (actions) VARCHAR, Interacting (settings) VARCHAR) CREATE TABLE 2010–present (2010–present_id AUTO_INCREMENT PRIMARY KEY, Year INT, Date VARCHAR, Type VARCHAR, President VARCHAR, Location VARCHAR)  
SELECT Average FROM season_2006 WHERE Club = Chesterfield Spires