Table: soap_actors
Columns: actor
character
soap_opera
years
duration

Question: Which actor played on Home and Away for 20 years?
SQL: SELECT "actor" FROM soap_actors WHERE "duration" = '20 years' AND "soap_opera" = 'home and away'

Question: What character was portrayed by the same actor for 12 years on Neighbours?
SQL: SELECT "character" FROM soap_actors WHERE "duration" = '12 years' AND "soap_opera" = 'neighbours'

Question: How long did Joyce Jacobs portray her character on her show?
SQL: SELECT "duration" FROM soap_actors WHERE "actor" = 'joyce jacobs'

Question: Which actor played Harold Bishop for 17 years?
SQL: SELECT "actor" FROM soap_actors WHERE "duration" = '17 years' AND "character" = 'harold bishop'

Question: Which years did Martin Sacks work on a soap opera?
SQL: SELECT "years" FROM soap_actors WHERE "actor" = 'martin sacks'