CREATE TABLE table_name_47 (character VARCHAR2, duration VARCHAR2)

what is the character with the duration of 11 years?
SELECT character FROM table_name_47 WHERE duration = "11 years"
SELECT "character" FROM "table_name_47" WHERE "11 years" = "duration"