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: Que prêmio a Charlie Productions Ltd recebeu?
 ###Tabelas: CREATE TABLE belgium_cd_track_listings (belgium_cd_track_listings_id AUTO_INCREMENT PRIMARY KEY, Track INT, Title VARCHAR, Songwriter(s) VARCHAR, Producer(s) VARCHAR, Length VARCHAR) CREATE TABLE singles_finals_19_8–11 (singles_finals_19_8–11_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Location VARCHAR, Surface VARCHAR, Opponent in final VARCHAR, Score VARCHAR) CREATE TABLE 2006 (2006_id AUTO_INCREMENT PRIMARY KEY, Film VARCHAR, Director(s) VARCHAR, Recipient VARCHAR, Date VARCHAR, Award VARCHAR) CREATE TABLE by_year (by_year_id AUTO_INCREMENT PRIMARY KEY, Year INT, Winner (number of titles) VARCHAR, Runners-up VARCHAR, Top Team in Regular Season (points) VARCHAR, Top Scorer (points) VARCHAR, Winning Coach VARCHAR) CREATE TABLE list_of_blood_agents (list_of_blood_agents_id AUTO_INCREMENT PRIMARY KEY, Agent VARCHAR, Melting / boiling point VARCHAR, Effectiveness as blood agent INT, Persistence, open area INT, Persistence, enclosed area INT, Field stability INT, Storage stability INT, Toxicity as blood agent INT)  
SELECT Award FROM 2006 WHERE Recipient = charlie productions ltd