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: O clube Crvena Zvezda tem qual agregado?
 ###Tabelas: CREATE TABLE european_competition_history (european_competition_history_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Competition VARCHAR, Round VARCHAR, Club VARCHAR, Home VARCHAR, Away VARCHAR, Aggregate VARCHAR) CREATE TABLE list_of_alt_flights (list_of_alt_flights_id AUTO_INCREMENT PRIMARY KEY, Test flight VARCHAR, Date VARCHAR, Speed VARCHAR, Altitude VARCHAR, Crew VARCHAR, Duration VARCHAR, Comment VARCHAR) CREATE TABLE singles_6–6 (singles_6–6_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Opponent VARCHAR, Score VARCHAR) CREATE TABLE champions_and_top_goalscorers (champions_and_top_goalscorers_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Champion VARCHAR, Runner-Up VARCHAR, 3rd Position VARCHAR, Top Goalscorer(s) VARCHAR, Team(s) INT) CREATE TABLE performances_by_nations (performances_by_nations_id AUTO_INCREMENT PRIMARY KEY, # INT, Nation VARCHAR, Winners INT, Runners-up INT, 3rd Place INT, 4th Place INT)  
SELECT Aggregate FROM european_competition_history WHERE Club = crvena zvezda