How many years did the soap opera run in which the character Clemens Richter was included?
CREATE TABLE table_name_2 (duration VARCHAR, character VARCHAR)
SELECT duration FROM table_name_2 WHERE character = "clemens richter"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_2 (duration VARCHAR, character VARCHAR) Question: How many years did the soap opera run in which the character Clemens Richter was included? [/INST] SELECT duration FROM table_name_2 WHERE character = "clemens richter" </s>