Table: soap_actors_4
Columns: actor
character
soap_opera
years
duration

Question: What's the duration of the Archers with Norman Painting as an actor?
SQL: SELECT "duration" FROM soap_actors_4 WHERE "soap_opera" = 'the archers' AND "actor" = 'norman painting'

Question: What's the duration of the Archers with Pauline Seville acting?
SQL: SELECT "duration" FROM soap_actors_4 WHERE "soap_opera" = 'the archers' AND "actor" = 'pauline seville'

Question: Who's the actor for the Archers having a character of Martha Woodford?
SQL: SELECT "actor" FROM soap_actors_4 WHERE "soap_opera" = 'the archers' AND "character" = 'martha woodford'

Question: Who's the character when Margot Boyd was acting?
SQL: SELECT "character" FROM soap_actors_4 WHERE "actor" = 'margot boyd'