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: Em que ano Herself foi indicado ao MTV Movie Awards?
 ###Tabelas: CREATE TABLE concacaf_women's_world_cup_qualifiers_record (concacaf_women's_world_cup_qualifiers_record_id AUTO_INCREMENT PRIMARY KEY, Year INT, Result VARCHAR, Matches INT, Wins INT, Draws INT, Losses INT) CREATE TABLE awards_and_nominations (awards_and_nominations_id AUTO_INCREMENT PRIMARY KEY, Year INT, Nominated work VARCHAR, Event VARCHAR, Award VARCHAR, Result VARCHAR) CREATE TABLE overall_standings (overall_standings_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Name VARCHAR, Nationality VARCHAR, Total points VARCHAR, Oberstdorf (Rk) VARCHAR, Ga-Pa (Rk) VARCHAR, Bhofen#1 (Rk) VARCHAR, Bhofen#2 (Rk) VARCHAR) CREATE TABLE women's_doubles:_10_finals_3_titles_7_runner-ups (women's_doubles:_10_finals_3_titles_7_runner-ups_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Year INT, Championship VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents in the final VARCHAR, Score in the final VARCHAR) CREATE TABLE opening_day_starting_lineups (opening_day_starting_lineups_id AUTO_INCREMENT PRIMARY KEY, Year INT, Catcher VARCHAR, First Baseman VARCHAR, Second Baseman VARCHAR, Shortstop VARCHAR, Third Baseman VARCHAR, Rightfielder VARCHAR, Centerfielder VARCHAR, Leftfielder VARCHAR, Starting Pitcher VARCHAR)  
SELECT MAX Year FROM awards_and_nominations WHERE Nominated work = herself AND Event = mtv movie awards