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: Para qual prêmio An Officer and a Gentleman foi indicado?
 ###Tabelas: CREATE TABLE principal_roles_and_cast_members (principal_roles_and_cast_members_id AUTO_INCREMENT PRIMARY KEY, Character VARCHAR, Original Manchester Performer VARCHAR, Original West End Performer VARCHAR, Original Broadway Performer VARCHAR, Original UK Tour Performer VARCHAR, Original Non-Equity US Tour Performer VARCHAR, Original Italian Tour Performer VARCHAR, Original South Korean Performer VARCHAR) CREATE TABLE current_situation (current_situation_id AUTO_INCREMENT PRIMARY KEY, Provider VARCHAR, Country VARCHAR, Subscribers (2005) (thousands) INT, Subscribers (2006) (thousands) INT, Growth % VARCHAR) CREATE TABLE awards_and_nominations (awards_and_nominations_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Award VARCHAR, Production VARCHAR, Role VARCHAR, Result VARCHAR) CREATE TABLE managerial_head_coach_changes (managerial_head_coach_changes_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Outgoing manager VARCHAR, Manner of departure VARCHAR, Date of vacancy VARCHAR, Incoming manager VARCHAR, Date of appointment VARCHAR) CREATE TABLE expeditions (expeditions_id AUTO_INCREMENT PRIMARY KEY, Expedition VARCHAR, Crew VARCHAR, Launch date VARCHAR, Flight up VARCHAR, Landing date VARCHAR, Flight down VARCHAR, Duration (days) VARCHAR)  
SELECT Award FROM awards_and_nominations WHERE Result = nominated AND Production = an officer and a gentleman