user: ### NOW ANSWER:
Question: What's the duration of The Archers with Norman Painting as an actor?
Columns: ['Actor', 'Character', 'Soap Opera', 'Years', 'Duration']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Lesley Saweard', 'Christine Barford', 'The Archers', '1953—', '61 years']
SQL:

assistant: SELECT "Duration" FROM "Table" WHERE "Soap Opera" = 'The Archers' AND "Actor" = 'Norman Painting';