Which year has a 2011 of 1r?
CREATE TABLE table_name_47 (Id VARCHAR)
SELECT 2008 FROM table_name_47 WHERE 2011 = "1r"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (Id VARCHAR) Question: Which year has a 2011 of 1r? [/INST] SELECT 2008 FROM table_name_47 WHERE 2011 = "1r" </s>