what is the character with the duration of 11 years?
CREATE TABLE table_name_47 (character VARCHAR, duration VARCHAR)
SELECT character FROM table_name_47 WHERE duration = "11 years"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (character VARCHAR, duration VARCHAR) Question: what is the character with the duration of 11 years? [/INST] SELECT character FROM table_name_47 WHERE duration = "11 years" </s>