Table: soap_actors_6
Columns: actor
character
soap_opera
years
duration

Question: Which actor plays the character Helga Beimer?
SQL: SELECT "actor" FROM soap_actors_6 WHERE "character" = 'helga beimer'

Question: How long did the soap opera run in which Nadine Spruß acted in?
SQL: SELECT "character" FROM soap_actors_6 WHERE "actor" = 'nadine spruß'

Question: How many years did the soap opera run in which the character Clemens Richter was included?
SQL: SELECT "duration" FROM soap_actors_6 WHERE "character" = 'clemens richter'

Question: What years did Marienhof run, which featured Leonore Capell and lasted 10 years?
SQL: SELECT "years" FROM soap_actors_6 WHERE "soap_opera" = 'marienhof' AND "duration" = '10 years' AND "actor" = 'leonore capell'