Table: soap_actors_8
Columns: actor
character
soap_opera
years
duration

Question: What are the years that have un posto al sole as the soap opera, with riccardo polizzy carbonelli as the actor?
SQL: SELECT "years" FROM soap_actors_8 WHERE "soap_opera" = 'un posto al sole' AND "actor" = 'riccardo polizzy carbonelli'

Question: What years have a duration of 18 years, and patrizio rispo as the actor?
SQL: SELECT "years" FROM soap_actors_8 WHERE "duration" = '18 years' AND "actor" = 'patrizio rispo'

Question: What are the years that have a duration of 15 years and giulia poggi as the character?
SQL: SELECT "years" FROM soap_actors_8 WHERE "duration" = '15 years' AND "character" = 'giulia poggi'

Question: What years have claudia ruffo as the actor?
SQL: SELECT "years" FROM soap_actors_8 WHERE "actor" = 'claudia ruffo'

Question: What is the duration that has pietro genuardi as the actor?
SQL: SELECT "duration" FROM soap_actors_8 WHERE "actor" = 'pietro genuardi'

Question: What is the soap opera that has a duration of 13 years, with marina giulia cavalli as the actor?
SQL: SELECT "soap_opera" FROM soap_actors_8 WHERE "duration" = '13 years' AND "actor" = 'marina giulia cavalli'