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 foi o agregado para Ricky Groves?
 ###Tabelas: CREATE TABLE population_and_distribution (population_and_distribution_id AUTO_INCREMENT PRIMARY KEY, Year INT, Numer of Jamaicans granted British citizenship INT, Naturalisation by residence INT, Naturalisation by marriage INT, Registration of a minor child INT, Registration by other means INT) CREATE TABLE 2007_list (2007_list_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Company VARCHAR, Headquarters VARCHAR, Industry VARCHAR, Sales (billion $) INT, Profits (billion $) INT, Assets (billion $) INT, Market Value (billion $) INT) CREATE TABLE list_of_wisden_trophy_series (list_of_wisden_trophy_series_id AUTO_INCREMENT PRIMARY KEY, Series VARCHAR, Season VARCHAR, Host VARCHAR, Tests INT, England INT, West Indies INT, Draw INT, Series result VARCHAR, Holder at the end of the series VARCHAR) CREATE TABLE works_team_entries (works_team_entries_id AUTO_INCREMENT PRIMARY KEY, Year INT, Chassis VARCHAR, Engine VARCHAR, Tyres VARCHAR, Pts. ‡ VARCHAR) CREATE TABLE list_of_contestants (list_of_contestants_id AUTO_INCREMENT PRIMARY KEY, Celebrity VARCHAR, Known for VARCHAR, Age INT, Professional VARCHAR, Series INT, Place VARCHAR, Dances INT, Highest score INT, Lowest score INT, Aggregate INT, Average VARCHAR)  
SELECT MAX Aggregate FROM list_of_contestants WHERE Celebrity = Ricky Groves