What is the latest year they were nominated?
CREATE TABLE table_name_44 (year INTEGER, result VARCHAR)
SELECT MAX(year) FROM table_name_44 WHERE result = "nominated"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_44 (year INTEGER, result VARCHAR) Question: What is the latest year they were nominated? [/INST] SELECT MAX(year) FROM table_name_44 WHERE result = "nominated" </s>