Table: soap_actors_3
Columns: actor
character
soap_opera
years
duration

Question: who is the actor that played rachel mckenna?
SQL: SELECT "actor" FROM soap_actors_3 WHERE "character" = 'rachel mckenna'

Question: who is the actor for shortland street for the years 1993–1999, 2001–2003, 2007, 2009—?
SQL: SELECT "actor" FROM soap_actors_3 WHERE "soap_opera" = 'shortland street' AND "years" = '1993–1999, 2001–2003, 2007, 2009—'

Question: what is the soap opera when the years are 2000–2004, 2005—?
SQL: SELECT "soap_opera" FROM soap_actors_3 WHERE "years" = '2000–2004, 2005—'

Question: what is the character with the duration of 11 years?
SQL: SELECT "character" FROM soap_actors_3 WHERE "duration" = '11 years'

Question: what is the soap opera for elin sogn?
SQL: SELECT "soap_opera" FROM soap_actors_3 WHERE "actor" = 'elin sogn'